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

112 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
mordants113714(None) 
mordant10312401mordant_
mordents1138811mordents
fondants1246202fondants
formants13269952formants
jordans1566832jordan_s
mordancy1644192mordancy
mordanted1344412mordanted
mordantly1543682mordantly
mordent10313992mordent_
morgans10310122morgan_s
abradants1243893abradants
boranes93720403bor_anes
brants85723053_br_ants
coolants1039943coolants
coranto9311893cor_anto
corantos10310103cor_antos
corbans11313173corban_s
cordages12310113cordages
cordate10315223corda_te
cordings123011353cordings
cordons104415763cordon_s
corybants1644433corybants
courants10310803courants
currants1037933currants
dopants1038433do_pants
dormant102814373dormant_
errants7410643_errants
fondant11311143fondant_
forints10411833for_ints
formant123416003formant_
formats123113573forma_ts
gardant9314463gardant_
gormands1266563gormands
grants73722473_gr_ants
guardants1143793guardants
hydrants1585793hydrants
jordan1468063jordan__
jurants14379213jur_ants
korats105416063kor_a_ts
lorans65117603lor_an_s
lordings10368503lordings
lurdanes936063lurdanes
lurdans837073lurdan_s
maranta9311693mar_anta
marantas10310023mar_antas
margents11410133margents
marranos1038423marranos
mediants11299493mediants
merchants1646223merchants
migrants1138183migrants
moans74624373mo__an_s
moats75827643mo__a_ts
modals93914453mo_da_ls
moldings12267203moldings
moments113113123mo_ments
montanes101114523montanes
moorlands1244203moorlands
moraines10314363moraines
morales93619403mor_ales
morals85324633mor_a_ls
moras76438783mor_a__s
morass84614503mor_a_ss
morays114613883mor_a_ys
mordacity1743513mordacity
mordancies1544703mordancies
mordanting1444003mordanting
moreens939963moreen_s
morgan9311373morgan__
morganite1247423morganite
morganites1346723morganites
morgens10310463morgen_s
morions94014643morion_s
mornings11297923mornings
morns75527443mor__n_s
morons84919543mor_on_s
mortals93914003morta_ls
mortars93411523morta_rs
morts75533563mor___ts
mounts84115073mo__unts
mutants938583m_utants
norlands936443norlands
octants9128733_octants
odorants946043odor_ants
orangs74116033_or_angs
ordains879653_ordains
ordines83014903_ordines
organs7912913_organ_s
orients7311583_orients
oxidants1643933oxidants
pedants10310113_pedants
pendants1139093pendants
portents103512823portents
rants55935343__r_ants
rodents8611543ro_dents
sardanas937813sardanas
servants1138003servants
soldans83210403soldan_s
sonants7511233so_nants
sorbents10279133sorbents
sordines92414073sordines
soudans8309353soudan_s
torments10310453torments
torrents838143torrents
truants738163_truants
tyrants1037453tyr_ants
variants1139203variants
verdant11313293verdant_
versants1137783versants
warrants1168503warrants
wordages1337053wordages
wordings13328563wordings

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.436409841.7
2DLD Change Limit1461621127.59319249.6
3Display Results1121120.0303733.3
 (SQL Overall)1786911128.05922172.9
 
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.