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

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

95 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
haints9441758(None) 
faints94818781faints
haint85436321haint_
hants86335401ha_nts
haunts95614391haunts
hints87330621h_ints
paints85921831paints
saints65122421saints
taints64520531taints
ains46158892_ain_s
airts55626342_airts
aits46355542_ai_ts
ants47243472_a_nts
aunts55227632_aunts
baits76630582bai_ts
bints76130182_bints
cains75334302cain_s
cants77036942ca_nts
chaines124518732chaines
chains114819702chain_s
chants115020392cha_nts
chaunts1267082chaunts
chints115117832chints
dainty105311472dainty
daunts75014082daunts
dints67431312_dints
elints65816422elints
faint85837062faint_
feints94813872feints
flints95617452flints
gains65729512gain_s
gainst74914702gainst
gaits65726012gai_ts
giants74713502giants
glints75714212glints
habits113014652habits
haets86525122ha_ets
hafts116219462ha_fts
haiks125120932hai_ks
haikus13538292haikus
hails85231642hai_ls
hairnets1195632hairnets
hairs86225172hai_rs
halts85230102ha_lts
hands95327382ha_nds
hangs95726732ha_ngs
hanks126226862ha_nks
hant75461592ha_nt_
harts88441592ha_rts
hats76858252ha__ts
haunt85229132haunt_
hayings14379392hayings
hazings20378342hazings
heists96814632heists
hents87330742h_ents
hilts86924412h_ilts
hinds96721482h_inds
hins76448002h_in_s
hint77455752h_int_
hists86328372h_ists
hits75545142h_i_ts
hoists95516022hoists
hunts86826172h_unts
jaunts137511882jaunts
joints133811452joints
kainits1137762kainits
kains96125652kain_s
lints57137192_lints
mains75635112main_s
maists85817572maists
mints76834042_mints
pains75138282pain_s
paint75443692paint_
painty114714752painty
pants76536922pa_nts
pints75936222_pints
plaints94012062plaints
points85618532points
prints84320102prints
quints154316562quints
rains55140232rain_s
rants55935342ra_nts
sains55639972sain_s
saint55147072saint_
stints65119762stints
suints64617782suints
tains54936322tain_s
taint55542282taint_
taunts65715662taunts
tints56030922_tints
vaunts95212622vaunts
wains86930872wain_s
waists97415452waists
waits88333522wai_ts
wants87932212wa_nts

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551952.53032628.9
3Display Results95950.0332878.8
 (SQL Overall)178691952.92361132.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.