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

390 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
mourner93808(None) 
mourned1037761mourned
mourners1036911mourners
bourne83714092bourne_
bournes93615022bournes
burner83819202_burner
churner12298342churner
corner84625622co_rner
courier93617872courier
courser94114802courser
courter94516462courter
dourer74215272dour_er
journey1734872journey
moaner84415112mo_aner
moderner1145522moderner
mooner85317832mo_oner
moorier93113072moorier
moulder10389802moulder
moulter93812422moulter
mounter93713172mounter
mourn77215012mourn__
mourns84111012mourn_s
mouser85822442mou_ser
mousier93712462mousier
mouther123812812mouther
murder93613782m_urder
murker123715242m_urker
pourer84516042pour_er
sorner64720382so_rner
sourer63620212sour_er
spurner9269652spurner
tourer64115072tour_er
tourney1036272tourney
turner63914612_turner
adorner8246973adorner
armourer1054883armour_er
blurter9419833blurter
boarder103910323boarder
boner75133083bo__ner
border94419973bo_rder
borer75131273bo_r_er
borne77926793bo_rne_
boulder103411343boulder
bouncer113811333bouncer
bounder104215533bounder
bourn75518483bourn__
bourns84114063bourn_s
bourree91311343bourree
bourse84414333bourse_
bourses94014303bourses
bouvier1277433bouvier
burger94020793_burger
burier84324653_burier
burker125221173_burker
burler84723833_burler
burned95818963_burned
burners94115673_burners
burnet84326173_burnet
burrer83718473_burrer
churned13358373churned
churners13316883churners
coarser93211193coarser
coercer1138383coercer
coiner84323783co_iner
conner84423963co_nner
corder94322873co_rder
corer75538873co_r_er
corker124720853co_rker
cornea84018923co_rnea
corned95224523co_rned
cornel84020053co_rnel
corners94723313co_rners
cornet84436733co_rnet
cornier93017083co_rnier
coroner94218203coroner
coruler9311713coruler
coucher144515853coucher
cougher133711733cougher
coulter94115593coulter
counter94220143counter
coupler114713013coupler
couriers103213163couriers
course85117773course_
coursed104113603coursed
coursers104412293coursers
courses94218893courses
courted103514913courted
courters103015363courters
courtier1059313courtier
couter84930203cou_ter
couther123914623couther
cozener18328953cozener
cunner83915003_cunner
curber104517053_curber
curer75030753_cur_er
curler85221323_curler
curser84721473_curser
curter85320073_curter
darner74017303_darner
dormer94415893do_rmer
dorper94314563do_rper
dorser74819173do_rser
doubler103110083doubler
doubter10298353doubter
dourine8311443dourine_
dourines9311363dourines
dourness947683dourness
douser75621633dou_ser
downer104414923do_wner
dunner73913823_dunner
durned84113173_durned
earner63617223_earner
forcer114917343fo_rcer
forger104820773fo_rger
forker134717903fo_rker
former114221403fo_rmer
fouler93614903fou_ler
founder114312563founder
funner93414103_funner
furler93616403_furler
garner73917003_garner
goner66025163go__ner
gorger86116983go_rger
gorier73719373go_rier
gouger86014363gou_ger
gourde8107933gourde_
gourdes9109383gourdes
gourmet1059203gourmet
goutier82612353goutier
gunner73813983_gunner
gurnet74920873_gurnet
gurney10429413_gurney
hoarder11329233hoarder
hoarier104211743hoarier
hoarser10388393hoarser
honer85332093ho__ner
horned105718703ho_rned
hornet94926433ho_rnet
hornier103012453ho_rnier
hounder113412233hounder
houser95322283hou_ser
hurler94717223_hurler
hurter93915853_hurter
impugner13444233impugner
impurer1136483impur_er
inurned8328053inurned
joiner134114133jo_iner
journal1484963journal
journeyer1942023journeyer
journeys1843203journeys
journo13135293journ_o
journos14134943journos
jouster143311043jouster
learner7319383learner
loaner64416503lo_aner
loner55431043lo__ner
loriner7511883loriner
louder74414603lou_der
lounger84610213lounger
loured74617403lour_ed
lousier72411623lousier
louver94110393lou_ver
lurer54625313_lur_er
lurker103613293_lurker
manner84020513m_anner
manurer938583manur_er
mariner93315993mariner
marker124420393m_arker
marrer83716673m_arrer
marrier93817523marrier
maturer938973matur_er
mauger93813483mau_ger
mauler84416713mau_ler
maunder10328683maunder
meaner84617843m_eaner
mercer105214203m_ercer
merer75126233m_er_er
merger95016473m_erger
merrier92612303merrier
miner76933543m__iner
mirier83918363m_irier
mirker123712693m_irker
moaned94514173mo_aned
moaners92813553mo_aners
mobber123613463mo_bber
mobster11299213mobster
mocker143315443mo_cker
modeler1039293modeler
moderne1037123moderne_
modernes1138423modernes
moiler84017263mo_iler
moire71017323moir_e_
moires8915633moir_es
moister94015373moister
molder93819273mo_lder
moldier103110033moldier
moline84422033moline_
molter84119423mo_lter
momser104011413mo_mser
momzer19327553mo_mzer
money104826843mo__ney
moneyer1237903moneyer
monger94418333mo_nger
moniker1338673moniker
monomer11311893monomer
monster93214593monster
moocher143610673moocher
moodier103212203moodier
mooned94216643mo_oned
mooners94015343mo_oners
moonier93714103moonier
moored93814173moor_ed
moorhen1236023moorhen
mooter83921093mo_oter
moper94925923mo__per
mopier103914783mo_pier
mopper126215003mo_pper
morae75831193mo_rae_
more67154523mo_r_e_
moreen8313343mo_reen
morel75729093mo_r_el
mores76249643mo_r_es
morgen9312203mo_rgen
morn66237563mo_rn__
morns75527443mo_rn_s
morse76032703mo_rse_
morsel85815893mo_rsel
mortar83812043mo_rtar
morular978223morular
mosher114719793mo_sher
mosser84618273mo_sser
mossier94413813mossier
mother113718643mo_ther
mothier121910213mothier
motioner1037593motioner
motlier92010583motlier
mottler94410343mottler
mouched153612593mouched
mouches143815963mouches
moue65835573mou__e_
moues75732843mou__es
moulded11348063moulded
moulders11348333moulders
mouldier1154953mouldier
moulted103310313moulted
moulters103510773moulters
mound83918313mou_n_d
mounded113711983mounded
mounds93915133mou_nds
mount74128063mou_n_t
mounted103611533mounted
mounters103712493mounters
mounts84115073mou_nts
mournful1342503mournful
mourning1156793mourning
mouse77133003mou_se_
moused94423303mou_sed
mousers95216443mou_sers
mouses85531423mou_ses
mousey115216193mou_sey
mousse84813033mousse_
moussed10338913moussed
mousses94012703mousses
mouthed133811043mouthed
mouthers133811303mouthers
mouthier13208173mouthier
mover104220863mo__ver
mower104523453mo__wer
mucker143816393m_ucker
mudder104413493m_udder
mugger103914703m_ugger
muller83820353m_uller
mummer93614543m_ummer
mumper123513523m_umper
murders103311363m_urders
mure65941333m_ur_e_
mured85726703m_ur_ed
mures75937213m_ur_es
murex145517173m_ur_ex
murine84220023m_urine_
murines93718223m_urines
murkier133110263m_urkier
murmur1034853m_urmur
murr65225133m_ur__r
murre74821073m_urre_
murres85019043m_urres
murrey114312253m_urrey
murther1237953m_urther
muser76024123m_u_ser
musher113820573m_usher
muster84724523m_uster
muter74525543m_u_ter
mutter84418883m_utter
nurser64314503_nurser
opener83910993_opener
order65019363_o_rder
ormer75218373_o_rmer
ornery938463_o_rnery
ourie54027293_ourie_
ouster64223733_ouster
outer55633303_ou_ter
owner84613313_o_wner
poorer82613993poor_er
porker124917543po_rker
pornier93413123po_rnier
porter84224413po_rter
poulter93712013poulter
pouncer113511233pouncer
pounder103313993pounder
poured95116743pour_ed
pourers93513673pour_ers
pouter83923983pou_ter
poutier93215323poutier
pruner83413453pru_ner
punner84918153_punner
purer75127903_pur_er
purger94717233_purger
purser85020473_purser
returner8397983returner
roarer63914333roar_er
roturier836033roturier
rougher113511033rougher
rounder83514593rounder
roupier9319493roupier
rouser65224083rou_ser
rouster73517083rouster
router65025843rou_ter
ruiner64013643_ruiner
runner63814463_runner
scorner9259763scorner
scourer93910433scour_er
scourger1134723scourger
scunner9358243scunner
shunner10358643shunner
smoulder1133443smoulder
soarer64522243soar_er
sojourner1661713sojourner
sooner64220463so_oner
sorer56236573so_r_er
sorned74820043so_rned
sorners73416863so_rners
sorrier72313723sorrier
sorter64425083so_rter
sounder83315383sounder
soupier93111753soupier
source8410673source_
sourced1038453sourced
sources9312173sources
soured74921863sour_ed
sourness839543sourness
souter64225923sou_ter
souther104116303souther
spurned10339263spurned
spurners10288493spurners
spurrer93710213spurrer
spurter94013003spurter
sterner7411913sterner
stunner7349193stunner
surer54833093_sur_er
surfer93515883_surfer
surger74320093_surger
toner55336243to__ner
tonner64819203to_nner
toucher124814353toucher
tougher114210983tougher
toured74216153tour_ed
tourers73512733tour_ers
tourneys1134013tourneys
touter63821033tou_ter
tuner56022683_tu_ner
turned73914473_turned
turners73912893_turners
turnery10357423_turnery
unmourned1254153unmourned
urger64116473__urger
usurer638103usur_er
usurper934353usurper
voucher154110263voucher
warner93717223_warner
wonner95114443wo_nner
worker134715113wo_rker
wormer114514913wo_rmer
worrier102311673worrier
worser95117523wo_rser
yarner93313063_yarner
yearner10336873yearner
younger11387163younger
younker14316453younker
yourn87512773yourn__
zoner144520343zo__ner

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 Limit1340273907.47017942.0
3Display Results3903900.1402785.7
 (SQL Overall)1786913907.76623009.4
 
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.