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

394 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
mortise971353(None) 
amortise10428511amortise
mortice11711491mortice
mortised1178741mortised
mortiser1078471mortiser
mortises10713601mortises
amortised1285812amortised
amortises1178822amortises
amortize1987742amortize
forties104323862forties
fortis95418612fortis_
monetise10311472monetise
moraine9314572moraine
moralise10314912moralise
morose85116242mor_ose
morris83814722morris_
morrises10711062morrises
morse76032702mor__se
morticed1377162morticed
mortices12711552mortices
mortify1536222mortify
mortisers1186162mortisers
morts75533562mort_s_
motile83818342mo_tile
motive113112142mo_tive
poetise9314042poetise
sortie63621982sorti_e
sorties74126402sorties
tortile7313192tortile
tortoise847092tortoise
unmortise1144482unmortise
abortive1346883abortive
airtime948063airtime
airwise1036713airwise
amorist9317643amor_ist
amortized2185923amortized
amortizes2087273amortizes
aorist64827873aor_ist
aortae65115473aort_ae
aortas65417783aortas_
aortic8316613aorti_c
arise56436433_ar_ise
artist64125543_artist
artiste73813693_artiste
azotise1637073azotise
baptise1139553baptise
betise85616273_betise
bootie85421153booti_e
booties94124613booties
boride9415903bor_ide
bornite9311183bornite
borts76735453bort_s_
bortzes1838223bortzes
braise84318753_braise
bruise83412873_bruise
cerise84822043cer_ise
coatis85122593coatis_
cognise1059683cognise
coltish121310933coltish
concise11314473concise
contuse9311413contuse
cootie84223073cooti_e
cooties93725733cooties
corbie103618203corbi_e
corbies113520113corbies
cordite10315253cordite
corgis9314403corgis_
cornice11612933cornice
corpse104013403cor_pse
corrie83621213corri_e
corries94026783corries
corse75036183cor__se
cortege1098943cortege
cortices12615003cortices
corticose1346043corticose
cortin82423143corti_n
cortina91915963cortina
cortins92421313cortins
cortisol1045403cortisol
cortisone1147043cortisone
corvine122113643corvine
costive12312843costive
cruise84314043_cruise
dirties83119383dirties
doltish11118733doltish
dories75232363dor_ies
dormice1237133dormice
dormie9312623dormi_e
emotive1239193emo_tive
emprise11310723empr_ise
erotism9312293erotism
erotize16311653erotize
exorcise1745933exorcise
fertile10311733fertile
footie94718133footi_e
footies103721543footies
footsie1047643footsie
foretime1348213foretime
forgive1436193forgive
forte86131463fort__e
fortes95327183fortes_
fortify1636523fortify
forts86034453fort_s_
fortune1068303fortune
fortyish1744843fortyish
fraise94214913_fraise
frise85322453_fr_ise
furtive1337173furtive
goatish1139563goatish
gorse65926813gor__se
hogtie102711763hogti_e
hogties112813993hogties
hoise85224773ho__ise
hornist102314823hornist
horse86132653hor__se
hostile10312553hostile
hottie92514363hotti_e
hotties103016953hotties
hottish13117893hottish
iodise74214933io_dise
ionise63516933io_nise
lories64933043lor_ies
loris55329153lor_is_
lorises73918593lor_ises
lorries74518343lorries
loutish1039963loutish
malaise9312673malaise
maltase938903maltase
maltose939783maltose
mantis83926033mantis_
mantises10317923mantises
manwise1239183manwise
marine84230403mar_ine
marish114319053mar_ish
maritime1247383maritime
marline93320953marline
marlite92917073marlite
marmite112413993marmite
marquise19206173marquise
marries93825283marries
marse76231153mar__se
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
marts77442233mart_s_
memorise121411433memor_ise
mercies113817563mercies
merises93421423mer_ises
merits8320873merits_
metis75025903m_etis_
metisse936503m_etisse
metrist9317063metrist
mirths114912993mirths_
mise66043573m___ise
misraise10410523misraise
mistime11312613mistime
mitis75425983m_itis_
mitises9315543m_itises
moating104218153moating
moatlike1446993moatlike
moats75827643moat_s_
mobbish1635923mobbish
mobbism1535053mobbism
mobile103613533mo_bile
mobilise1248143mobilise
modernise1244733modernise
modish123813543mo_dish
modiste1039283mo_diste
moggie103210103moggi_e
moggies113111723moggies
moieties10311263moieties
moire71017313mo__ire
moist76033573mo__ist
molies84429513mo_lies
moline84422033mo_line
mollie83517103molli_e
mollies93420233mollies
molting103517173molting
molts76032093molt_s_
momism93410353mo_mism
mommies103912273mommies
monetised1246973monetised
monetises11311043monetises
monetize1949983monetize
monie75631653mo_ni_e
monies83233163mo_nies
monish114217593mo_nish
monism104016313mo_nism
monist84324983mo_nist
monitive1349993monitive
monkish1638243monkish
montage101211713montage
montane91313623montane
monte75829773mont__e
montes84226933montes_
months113812933months_
moonish123311043moonish
moonrise1046783moonrise
moorish123311783moorish
moose76327193mo__ose
mooting103019363mooting
moots75831663moot_s_
mopish134311593mo_pish
morae75831193mor__ae
moraines10314343moraines
morale85220553mor_ale
morales93619403morales
moralised1239663moralised
moralises11314003moralises
moralism12312363moralism
moralist10316663moralist
moralize19313923moralize
morals85324633morals_
moras76438763mor_as_
morass84614493mor_ass
morasses1038903morasses
morassy12495043morassy
morays114613883morays_
morbid112511463morbi_d
more67154523mor___e
morelle91210803morelle
morels84820013morels_
mores76249643mor_es_
morgue938113mor_gue
morgues1038273morgues
morion86217733mor_ion
morning103215043morning
morns75527443mor_ns_
moronism1249323moronism
morons84919543morons_
morphine1548703morphine
morphs13149433morphs_
morrion959003morrion
morros83714673morros_
mors65950063mor__s_
morsel85815893mor__sel
mort66758833mort___
mortal84616853mort_al
mortals93914003mortals
mortar83812043mort_ar
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
mortgage1244213mortgage
mortified1547373mortified
mortifier1446913mortifier
mortifies1439393mortifies
mortising1238693mortising
morulae958963morulae
moste75925083most__e
mostest9314793mostest
mosts76028543most_s_
mote67048083mo_t__e
motes75944003mo_tes_
moths106021553mo_ths_
motif10519663mo_ti_f
motifs1139673mo_tifs
motiles93317433mo_tiles
motion85217553mo_tion
motived13357763mo_tived
motives123611893mo_tives
motorise10311523motorise
mots66853163mo_t_s_
motte75526973mo_t_te
mottes85523693mottes_
mottle84116053mo_ttle
mottles93415803mottles
mottoes93412193mottoes
mottos84615243mottos_
motts76527003mo_tts_
mouse77133003mo__use
mousse84813033mo_usse
mouths115214533mouths_
movie105319133mo_vi_e
movies115118453mo_vies
moxie144018123mo_xi_e
moxies154317403mo_xies
muftis1158053muftis_
multiuse1046513multiuse
murine84220023mur_ine
murries94118673murries
murrine9411473murrine
mutase82811983m_utase
mutine84420373m_utine
mutism103211463m_utism
myrtle1135733myrt_le
myrtles1235733myrtles
noise55723733no__ise
noris54928273nor_is_
norite63221133nor_ite
norites74018803norites
norths96812323norths_
notice8313443no_tice
nowise9511073no_wise
obtuse8147483_obtuse
oorie53026363oor_i_e
optime1079343_optime
oreide7311673_oreide
orgies72316093_orgies
ornis54616773_ornis_
oroide7311703_oroide
orpine83914483_orpine
orrice81410163_orrice
orris54516553_orris_
orrises71312233_orrises
orts46538333_ort_s_
otiose639403_o_tiose
parties93230863parties
partite9317133partite
parvise124211693parvise
poetised1138523poetised
poetiser1037313poetiser
poetises10313953poetises
poetize18310773poetize
poise75127893po__ise
pontine92419053pontine
porcine11312843porcine
porgies103017003porgies
porism104518063por_ism
porkies133416493porkies
porose84818743por_ose
porpoise1248073porpoise
portage103013643portage
portico11310143portico
portiere1038773portiere
porting103021783porting
portion9615493portion
ports75934593port_s_
portside1138163portside
postie84123963posti_e
posties93128813posties
potsie83916023po_tsie
potties93723543potties
poutine93316823poutine
praise84419413_praise
prise74632613_pr_ise
promise113415843promise
protist9320223protist
raise54828053__raise
reraise7316313reraise
rerise64325633rer_ise
rise45945233__r_ise
rotis56327053ro_tis_
routine72615903routine
shortie10411323shorti_e
shorties11414573shorties
shortish1437413shortish
smartie9310163smarti_e
smarties10312873smarties
softie93312473softi_e
softies103414613softies
softish13127813softish
sorbose938983sorbose
sordine82515223sordine
sorites73825243sorites
sorptive1346473sorptive
sortied83314093sortied
sorting83221813sorting
sorts54536663sort_s_
sottish10129433sottish
soubise9118793soubise
sportive1348333sportive
surmise9311083surmise
tartish101512633tartish
tontine72316143tontine
tootsie737123tootsie
tories65435883tor_ies
torose64317693tor_ose
torse55833333tor__se
tortas64918253tortas_
torte55431703tort__e
tortes64826053tortes_
tortoises947183tortoises
torts56138123tort_s_
torture738593torture
unmortised1343983unmortised
unmortises1244263unmortises
upraise9158603upraise
uprise82313693upr_ise
vortices1369123vortices
vorticose1444193vorticose
votive12348933vo_tive
wartime1237743wartime
wormish1537163wormish
worries104117133worries
worse86525263wor__se
worthies14310283worthies
worths127812893worths_
worts88631183wort_s_
zoris145320013zor_is_

Search took 8 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.1561145455.1
2DLD Change Limit1340273947.20318607.1
3Display Results3943940.1432755.2
 (SQL Overall)1786913947.50223819.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.