Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “mortiser” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mortiser107848(None) 
mortise9713531mortise_
mortised1178751mortised
mortisers1186171mortisers
mortises10713621mortises
amortise10428512amortise_
amortised1285812amortised
amortises1178822amortises
morrises10711072morrises
mortice11711492mortice_
morticed1377172morticed
mortices12711572mortices
mortifier1446922mortifier
poetiser1037312poetiser
amortize1987743amortize_
amortized2185933amortized
amortizes2087283amortizes
artier63419733_arti_er
artsier768943_artsier
bruiser9349573_bruiser
conciser12310243conciser
corkier133114303corki_er
cornier93017093corni_er
cortices12615023cortices
cortisol1045413cortisol
cottier93814173cotti_er
courtier1059333courti_er
cruiser93410433_cruiser
dirtier83312093dirti_er
dorkier122810023dorki_er
dorser74819183dor__ser
dotier73917033do_ti_er
dottier83910923dotti_er
exorciser1843743exorciser
footier104115113footi_er
forgiver1534183forgiver
forkier144311593forki_er
forties104323863forti_es
fortifier1546253fortifier
fortis95418613fortis__
gorier73719373gor_i_er
gorsier83811073gorsi_er
goutier82612353gouti_er
hootier104915353hooti_er
hornier103012463horni_er
horrider1236533horrider
horsier103013243horsi_er
joltier14318493jolti_er
loftier1037763lofti_er
lorimer937753lor_imer
loriner7511893lor_iner
lorises73918593lor_ises
maltier93015483malti_er
mantises10317923mantises
mariner93316003mar_iner
marlier92614783marli_er
marrier93817523marri_er
martinet10319653martinet
matier84321523m_ati_er
meatier93214613meati_er
merises93421423mer_ises
merrier92612303merri_er
metier83517693m_eti_er
miltier93214963milti_er
mintier93615993minti_er
mirier83918363mir_i_er
mirkier13319053mirki_er
miser75430403m___iser
mistier93418713misti_er
mitier83620673m_iti_er
mitises9315543m_itises
moiler84017263mo__iler
moister94015373mo__ister
moldier103110033moldi_er
molter84119423molt__er
momser104011413mo__mser
monetise10311473monetise_
monetised1246973monetised
monetises11311043monetises
moniker1338673mo_niker
moodier103212203moodi_er
moonier93714103mooni_er
moorier93113073moori_er
mooter83921093moot__er
mopier103914783mo_pi_er
moraine9314573moraine_
moraines10314373moraines
moralise10314913moralise_
moralised1239663moralised
moralises11314003moralises
moralizer2049473moralizer
morasses1038903morasses
moreover1344863moreover
morose85116243mor_ose_
morris83814733morris__
morse76032703mor__se_
morsel85815893mor__sel
mortar83812043mort__ar
mortared1137213mortared
mortgager1342513mortgager
mortified1547383mortified
mortifiers1544403mortifiers
mortifies1439393mortifies
mortify1536223morti_fy
mortising1238693mortising
morts75533563mort_s__
mosser84618273mo__sser
mossier94413813mossi_er
mother113718643mo_t_her
mothier121910213mo_thier
motile83818343mo_tile_
motiles93317433mo_tiles
motioner1037593mo_tioner
motive113112143mo_tive_
motived13357763mo_tived
motives123611893mo_tives
motlier92010583mo_tlier
mottler94410343mo_ttler
mouser85822443mo__user
mousier93712463mousi_er
mouther123812813mout_her
mouthier13208173mouthier
multiuser1144983multiuser
murkier133110273murki_er
murther1237953murt_her
mustier94017963musti_er
norther1039733nort_her
noticer937273no_ticer
obtuser9134453_obtuser
orbier839993_orbi_er
orbiter937853_orbiter
orrises71312233_orrises
partier93520713parti_er
poetise9314043poetise_
poetised1138523poetised
poetisers1145313poetisers
poetises10313953poetises
poetizer1936813poetizer
poiser84217243po__iser
porkier133712343porki_er
pornier93413133porni_er
porter84224413port__er
portiere1038773porti_ere
portioner1158693portioner
portlier1038373portlier
pottier93516493potti_er
poutier93215323pouti_er
praiser93413943_praiser
promiser122510673promiser
purtier93214093purti_er
raiser66620103__raiser
riser55431053__r_iser
rootier74915393rooti_er
rotifer1036993ro_tifer
sootier73916613sooti_er
sorrier72313733sorri_er
sorter64425093sort__er
sortie63621993sorti_e_
sortied83314103sorti_ed
sorties74126403sorti_es
sportier102010053sporti_er
surmiser1036763surmiser
tartier74123263tarti_er
torrider936173torrider
tortile7313193tortile_
tortoise847093tortoise_
tortoises947183tortoises
torturer835493torturer
unmortise1144483unmortise_
unmortised1343993unmortised
unmortises1244263unmortises
upraiser10175843upraiser
upriser9218763upr_iser
vortices1369133vortices
wartier103413913warti_er
wordier112511213wordi_er
wormier12278763wormi_er
worrier102311683worri_er
worser95117523wor__ser
worthier1436713worthier
zootier163611173zooti_er

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621817.92018454.8
3Display Results1811810.0802262.5
 (SQL Overall)1786911818.42321214.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.