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

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
faintish144619(None) 
faintest1139072faintest
fainting123312162fainting
faints94818782faint_s_
fairish1338992fai_rish
fattish1359262fa_ttish
finfish16268192f_infish
finish124613422f_in_ish
antis55033313_a_ntis_
bairnish1345473bairnish
baitfish1645483baitfish
banish111416063ba_n_ish
brainish1338813brain_ish
brinish1239963brin_ish
cattish12410723ca_ttish
daintier937403daintier
dainties9312403dainties
daintiest1039153daintiest
daintily1245523daintily
danish101513813da_n_ish
faddish15359003fa_ddish
fainest10417703fain_est
faint85837063faint___
fainted114211723faint_ed
fainter103611053faint_er
fainters11349693fainters
faintly1337083faint_ly
faintness1235833faintness
fairyism1643513fairyism
faith115620853fai_t__h
faiths124610273fai_ths_
fallfish1744463fallfish
famish14311853fa__mish
fantasm1236593fa_ntasm
fantast10311703fa_ntast
fantasy1336153fa_ntasy
fanwise1336633fa_nwise
feinting123410833feinting
feints94813873feint_s_
fetish12310373f__etish
fiendish1544033fiendish
fiftyish2042553f_iftyish
finis86824263f_in_is_
flattish1455263flattish
flintier1136393flintier
flintiest1248443flintiest
flintily1434893flintily
flinting123412343flinting
flints95617453flint_s_
furnish1337383furn_ish
garnish111610853garn_ish
giantism1155383giantism
haimish1537753hai_mish
haints94417583haint_s_
intis55121643__intis_
kainits1137763kainits_
latish92416183la__tish
macintosh1641703macintosh
maidish13239553mai_dish
mannish121710703ma_nnish
mantis83926033ma_ntis_
minish115216313_min_ish
minxish1936213_minxish
nannyish1443303nannyish
paintier1048793paintier
paintiest11310573paintiest
painting113614423painting
paints85921833paint_s_
panfish15229983pa_nfish
pinfish15319303_pinfish
pinkish16279113_pinkish
rainwash1443063rainwash
rankish14510393ra_nkish
rattish10510823ra_ttish
runtish1048693_runtish
sailfish1446053sailfish
sainting93215733sainting
saints65122423saint_s_
saltish10312163sa_ltish
sanitise81511813sanitise
skittish1544503skittish
swainish1444753swain_ish
swinish1347203swin_ish
tainting93613583tainting
taints64520533taint_s_
tannish101610583ta_nnish
tarnish101611883tarn_ish
tartish101512633ta_rtish
thinnish1454883thinnish
vanish121513233va_n_ish
varnish13169553varn_ish
waifish1637703wai_fish
whitish1635973whi_tish
winish124212273_win_ish
zanyish2235913za_nyish

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.423422437.4
2DLD Change Limit146162957.07620656.0
3Display Results95950.0332878.8
 (SQL Overall)178691957.53223724.2
 
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.