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 “mortice” 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.

264 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
mortice1171149(None) 
morticed1377161morticed
mortices12711561mortices
mortise9713531mortise
amortise10428512amortise
amortize1987742amortize
aortic8316612aortic_
cornice11612932cornice
cortices12615012cortices
dormice1237132dormice
moraine9314572moraine
mortify1536222mortify
mortised1178742mortised
mortiser1078472mortiser
mortises10713612mortises
motile83818342mo_tile
motive113112142mo_tive
notice8313442no_tice
orrice81410162_orrice
portico11310142portico
sortie63621992sorti_e
tortile7313192tortile
vortices1369122vortices
abortive1346883abortive
airtime948063airtime
amortised1285813amortised
amortises1178823amortises
amortized2185933amortized
amortizes2087283amortizes
aortae65115473aort_ae
article9310923_article
bodice11711423bo_dice
bootie85421163booti_e
boric98024223bor_ic_
boride9415903bor_ide
bornite9311183bornite
cootie84223093cooti_e
coppice1537483coppice
corbie103618203corbi_e
cordite10315263cordite
corniced1368593corniced
cornices12713293cornices
corniche1575923corniche
cornicle1258783cornicle
corrie83621233corri_e
cortege1098953cortege
cortical12412213cortical
corticate13410763corticate
corticose1346043corticose
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
corvine122113643corvine
costive12312843costive
dormie9312623dormi_e
dornick1435273dornick
emotive1239193emo_tive
entice81316863_entice
erotic82620273erotic_
erotica92811513erotica
erotics91914153erotics
erotize16311663erotize
fertile10311733fertile
footie94718143footi_e
force105324273for__ce
foretime1348213foretime
forgive1436193forgive
formic13310453formic_
formica1436443formica
fornices1369103fornices
fortalice1445773fortalice
forte86131463fort__e
forties104323863forties
fortify1636523fortify
fortis95418613forti_s
fortune1068303fortune
furtive1337173furtive
hogtie102711773hogti_e
hospice14117063hospice
hostile10312553hostile
hottie92514383hotti_e
justice1637423justice
lattice938433lattice
lorica8310443lor_ica
loricae938253lor_icae
lotic76420673lo_tic_
malice104818483m_alice
mantic104120903mantic_
marine84230403mar_ine
maritime1247383maritime
marline93320953marline
marlite92917073marlite
marmite112413993marmite
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
mastic103119173mastic_
mastiche1547173mastiche
mastics112614783mastics
matrices12312083matrices
metric10314683metric_
metrics11312363metrics
mice87442233m___ice
miotic103715753miotic_
miotics112710653miotics
mistime11312613mistime
moating104218153moating
moatlike1446993moatlike
mobile103613543mo_bile
modica11310063mo_dica
moggie103210103moggi_e
moire71017323mo__ire
moline84422033mo_line
mollie83517103molli_e
molting103517173molting
monetise10311473monetise
monetize1949983monetize
monie75631653mo_ni_e
monitive1349993monitive
montage101211713montage
montane91313623montane
monte75829773mont__e
monticule1344713monticule
mooting103019363mooting
morae75831193mor__ae
moraines10314363moraines
morale85220553mor_ale
moralise10314913moralise
moralize19313923moralize
morbid112511463morbi_d
more67154523mor___e
morelle91210803morelle
morgue938113mor_gue
morion86217733mor_ion
morning103215043morning
morocco1343523morocco
moronic11311863moronic_
morose85116243mor_ose
morphic1648693morphic_
morphine1548703morphine
morrion959003morrion
morris83814733morri_s
morrises10711073morrises
morse76032703mor__se
mort66758833mort___
mortal84616853mort_al
mortals93914013mortals
mortar83812043mort_ar
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
mortgage1244213mortgage
mortician1346993mortician
morticing1448013morticing
mortified1547383mortified
mortifier1446923mortifier
mortifies1439393mortifies
mortisers1186163mortisers
morts75533563mort__s
morulae958963morulae
mosaic10311143mosaic_
mosaics1138073mosaics
moste75925083most__e
mote67048083mo_t__e
motif10519683mo_ti_f
motifs1139673mo_tifs
motiles93317433mo_tiles
motion85217553mo_tion
motived13357763mo_tived
motives123611893mo_tives
motte75526973mo_t_te
mottle84116053mo_ttle
movie105319133mo_vi_e
moxie144018123mo_xi_e
murices112612283mur_ices
murine84220023mur_ine
murrine9411483murrine
mutine84420373m_utine
myotic133112313myotic_
myotics14257603myotics
myrica1336833myr_ica
myrtle1135733myrt_le
mystic132711643mystic_
mystics14279103mystics
noetic8514043noetic_
nordic939473nordic_
norite63221133nor_ite
noritic91213543noritic_
noticed1037863no_ticed
noticer937273no_ticer
notices9312283no_tices
novice1138433no_vice
office1435693_office
ontic74418573_ontic_
oorie53026363oor_i_e
optic93715183_optic_
optics102810183_optics
optime1079353_optime
oreide7311673_oreide
orgic8311823_orgic_
orifice1246343_orifice
oroide7311703_oroide
orpine83914483_orpine
orrices9129363_orrices
otic66624823_o_tic_
particle1239533particle
partite9317133partite
poetic10416843poetic_
poetics11312073poetics
poetise9314043poetise
poetize18310773poetize
police102918563po_lice
pontine92419053pontine
porcine11312843porcine
portage103013643portage
portance12310123portance
porticoed1445423porticoed
porticoes1348253porticoes
porticos1238373porticos
portiere1038773portiere
porting103021783porting
portion9615493portion
portside1138163portside
postiche1547793postiche
postie84123963posti_e
potiche1438043po_tiche
poultice1246063poultice
poutine93316823poutine
price93725413_pr_ice
rice64942913__r_ice
routine72615903routine
service1239093service
shortie10411343shorti_e
smartie9310173smarti_e
softie93312483softi_e
solstice1047223solstice
sorbic10310393sorbic_
sordine82515233sordine
soritic91414433soritic_
sorptive1346473sorptive
sortied83314103sortied
sorties74126403sorties
sorting83221813sorting
sportive1348333sportive
statice92614033statice
thrice114311573thr_ice
tontine72316143tontine
toric76529313tor_ic_
torics85118353tor_ics
torte55431703tort__e
tortoise847093tortoise
torture738593torture
trice75127493_tr_ice
unmortise1144483unmortise
vertices13612283vertices
voice104915323vo__ice
vortical1348863vortical
vorticose1444193vorticose
votive12348933vo_tive
wartime1237743wartime

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272646.23321502.8
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.