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 “dormient” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
dormient114845(None) 
diriment11410742diriment
doomiest112910452doomiest
dorkiest133111252dorkiest
dormant102814372dorm_ant
dormie9312622dormie__
dormin9312312dormi_n_
dormins10311272dormi_ns
orient6322532_or_ient
torment9316172torm_ent
wormiest13249542wormiest
adornment1246283adornment
barmiest125212783barmiest
boomiest122711843boomiest
comment1310317703co_mment
corkiest143114793corkiest
corniest102117303corniest
dement93825143d_em_ent
detriment1249693detriment
dirtiest93014203dirtiest
disorient10412523disor_ient
docent92918683do__cent
document1348663document
dodgiest11308713dodgiest
doggiest113410523doggiest
dolmen93911373dolm_en_
dolmens10388693dolm_ens
dominant1149513do_minant
domine92918253do_mi_ne
domines102918973do_mines
doming104218393do_mi_ng
domino92611493do_mi_no
doomier103610123doomie_r
dooming113112533doomi_ng
doormen1036753doorm_en_
dopiest103315993do_piest
dories75232363dor_ie_s
dorkier122810023dorkie_r
dormer94415903dorm_e_r
dormers104313923dorm_ers
dormice1237133dormi_ce
dotiest83717453do_tiest
dottiest92611393dottiest
dowdiest13328953dowdiest
downiest122710603downiest
doziest174012473do_ziest
driest74722753d_r_iest
ferment12315573ferm_ent
foamiest13289853foamiest
foment113718303fo_m_ent
forewent1439423forewent
forint9325023for_i_nt
forkiest153812303forkiest
formant123416003form_ant
forming133615733formi_ng
fornent10312933for_nent
forspent1348163forspent
forwent13310533for_went
garment10315233garm_ent
germiest11249913germiest
goriest82218743gor_iest
gorming112810833gormi_ng
gorsiest92511133gorsiest
homiest124116633ho_miest
horniest112814043horniest
horrent10313553hor_rent
horsiest112513263horsiest
loamiest102310203loamiest
loment84021473lo_m_ent
moment103319683mo_m_ent
mordent10313993mor_dent
oddment1145923oddm_ent
orbiest9312413_orbiest
orients7311583_or_ients
orpiment1247973_orpiment
porkiest143513713porkiest
porniest103214313porniest
portent93619643por_tent
prominent1349573prominent
reorient8613473reor_ient
roomiest102611993roomiest
sarment9318763sarm_ent
sorbent92915243sor_bent
sorriest8413883sorriest
stormiest1137003stormiest
torments10310453torm_ents
torrent7313413tor_rent
varment12313243varm_ent
varmint12311683varmi_nt
wordiest122311543wordiest
wormier12278763wormie_r
worming132811243wormi_ng
worriment1445583worriment

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 Filter1786911461620.406440125.6
2DLD Change Limit146162937.08020644.4
3Display Results93930.0303100.0
 (SQL Overall)178691937.51623774.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.