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

261 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
mordent1031399(None) 
mordant10312401mordant
mordents1138811mordents
ardent73022612_ardent
erodent8313822erodent
fornent10312932fornent
forwent13310532forwent
horrent10313552horrent
margent10316692margent
modest93818452mo_dest
moment103319682mo_ment
mordants1137142mordants
moreen8313342moreen_
moreens939962moreens
morgen9312202morgen_
morgens10310462morgens
orient6322532_orient
portent93619642portent
rodent7519242ro_dent
sorbent92915242sorbent
torment9316172torment
torrent7313412torrent
argent74023663_argent
arpent84822093_arpent
boldest102613063boldest
bordel94514573borde_l
bordels103911973bordels
border94419973borde_r
borders104317533borders
boreen8314313boreen_
boreens9310403boreens
brent75734133_br_ent
burden9412473burden_
burdens1039713burdens
cadent94120363_cadent
candent10417363candent
coagent10313983coagent
coden86128543co_den_
codens94821013co_dens
cogent9321003co_gent
coldest102514763coldest
comment1310317703comment
concent114422513concent
consent93723113consent
content94326153content
convent123919413convent
corded105923353corde_d
corder94322883corde_r
corders104520883corders
cording113620823cording
cordon95017293cordon_
cordons104415763cordons
cornet84436733corne_t
coronet94227173coronet
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
credent10313973credent
current9313693current
dent57158413___dent
docent92918683do_cent
dormant102814373dormant
dormient1148453dormient
emergent1149113emergent
evident1139993evident
ferment12315573ferment
fervent13310063fervent
foment113718303fo_ment
fondant11311143fondant
fondest11312403fondest
forded115020393forde_d
fording123717043fording
fordone1149383fordone
forest94926743for_est
forewent1439423forewent
forfeit1339203forfeit
forfend1435413forfend
forget106326393forge_t
forint9325023for_int
formant123416003formant
forspent1348163forspent
gardant9314463gardant
garden84215083garden_
gardens93312093gardens
garment10315233garment
gerent73223103ger_ent
godet7530043go_de_t
golden84411153golden_
goldest92411173goldest
gorget87123863gorge_t
gorhen1038893gorhen_
gorhens1137183gorhens
goriest82218743goriest
harden105718533harden_
hardens113815023hardens
hardest113118413hardest
hodden113811453hodden_
hoddens12378803hoddens
hoiden103612333hoiden_
hoidens11329083hoidens
holden104113953holden_
horde94623053horde__
horded115420483horde_d
hordein1138753hordein
hordeins1238323hordeins
hordes104921633horde_s
hording123517053hording
hornet94926433horne_t
hoyden13328933hoyden_
hoydens14347403hoydens
imprudent1444613imprudent
impudent1346283impudent
indent73021243_indent
jordan1468063jordan_
jordans1566833jordans
loden66621143lo_den_
lodens74315063lo_dens
loment84021473lo_ment
lorded84916733lorde_d
lording93115233lording
louden73711793louden_
loudens8368053loudens
loudest839933loudest
madden103912523madden_
maddens11359753maddens
maddest112311213maddest
maiden93512283maiden_
maidens10349663maidens
margents11410133margents
market123226043marke_t
marten84518263marten_
martens93714953martens
merde84320123merde__
merdes94518603merde_s
merest84725113mer_est
mermen10813813mermen_
midden104112853midden_
middens11379383middens
milden94113153milden_
mildens10339933mildens
mildest102812063mildest
miriest93619823miriest
mirkest13309723mirkest
misorient11510893misorient
missent94318713missent
mode75840303mo_de__
model84521693mo_de_l
models94216353mo_dels
modem103717143mo_de_m
modems114610763mo_dems
modern939523mo_dern
moderne1037123mo_derne
moderns1037963mo_derns
modes85537413mo_de_s
modesty13476983mo_desty
molded104414083molde_d
molder93819273molde_r
molders103315553molders
moldiest11249693moldiest
molding114213753molding
molest85022743mo_lest
molten83311813molten_
momenta11299853mo_menta
momento11348903mo_mento
moments113113123mo_ments
monde85723143monde__
mondes94322353monde_s
monument1289903monument
moodiest112712183moodiest
moorhen1236023moorhen_
moorhens1344853moorhens
mooriest102812723mooriest
mopiest113014293mopiest
moppet126915093moppe_t
morae75831193morae__
moraine9314573moraine
morceau1145573morceau
mordancy1644193mordancy
mordanted1344413mordanted
mordantly1543683mordantly
more67154523mor_e__
morel75729093mor_e_l
morels84820013mor_els
mores76249643mor_e_s
morgan9311373morgan_
morgans10310123morgans
morion86217733morion_
morions94014643morions
morn66237563mor__n_
morning103215043morning
morns75527443mor__ns
moron76925423mor_on_
morons84919543mor_ons
morse76032703morse__
morsel85815893morse_l
morsels94112653morsels
mort66758833mor___t
mostest9314793mostest
motet75641193mo_te_t
mount74128063mo__unt
movement1549433movement
murder93613783murde_r
murders103311363murders
murkest133110203murkest
nocent83217413no_cent
oddest81710863_oddest
oddment1145923_oddment
olden65114853_olden_
oldest72114093_oldest
ordeal779253_ordeal
order65019363_orde_r
orders74315993_orders
orgeat7515033_orgeat
orients7311583_orients
parent83230423par_ent
pendent10314723pendent
percent113520603percent
perpent112318813perpent
ponent82821593po_nent
porrect1159743porrect
portend103411193portend
portents103512823portents
potent84223353po_tent
prudent10310433prudent
rent46661243__r_ent
reorient8613473reorient
rerent63832453rer_ent
rident7520193_rident
rodents8611543ro_dents
sarment9318763sarment
serpent92916283serpent
sodden84011513sodden_
soddens9348413soddens
solvent10310833solvent
sorbents10279133sorbents
sorbet83924083sorbe_t
sordine82515233sordine
sordini8228963sordini
sordino8219443sordino
sorest65028003sor_est
sprent84522383spr_ent
strident9310173strident
student848343student
torments10310453torments
torrents838143torrents
torten65314353torten_
trident8314193trident
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
varment12313243varment
verdant11313293verdant
warden104515513warden_
wardens113711903wardens
wooden103610303wooden_
worded114316623worde_d
wordiest122311543wordiest
wording123014563wording
worsen95513873worsen_
worsens104610263worsens
worset96726583worse_t

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.406440125.6
2DLD Change Limit1340272616.78319759.3
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.28224538.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.