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 “feists” 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
feists9491531(None) 
deists74916431deists
feasts95116091feasts
feints94813871feints
feist86230071feist_
feisty12449291feisty
fests85828041fe_sts
fists85527541f_ists
foists95413981foists
heists96814631heists
ageists848492ageists
agists75713172agists
beasts84519722beasts
bemists113410702bemists
bests75932612be_sts
cists76624532_cists
deisms94411042deisms
deist64633592deist_
delists84414172delists
desists83611722desists
easts57530322_easts
exists134710912exists
faints94818782faints
fasts86429682f_asts
feases95422922feases
feast85932722feast_
feats86432752fe_ats
feigns10407752feigns
feint84732252feint_
felts85324542fe_lts
fess76529162fe_s_s
fesses94820252fesses
fest74949442fe_st_
fets75345942fe__ts
feudists1244462feudists
fiats85324482f_iats
fideists1245542fideists
fiesta938122fiesta
fiestas1038432fiestas
firsts95110922firsts
fiscs105311882f_iscs
fist76248422f_ist_
fits76043462f_i_ts
flints95617452flints
flirts95411482flirts
flits85625222fli_ts
foist85730972foist_
frises94124272frises
frisks13479262frisks
frits86129102fri_ts
fritts94613192fritts
frosts94214622frosts
geests75912162geests
gests66028812ge_sts
gists66026192_gists
grists74716482grists
heist87030912heist_
hests85829932he_sts
hists86328372_hists
hoists95516022hoists
jests125922452je_sts
joists134711032joists
kists95822112_kists
leasts64616412leasts
legists899592legists
lists56628692_lists
maists85817572maists
mists76633902_mists
neist54628442neist_
nests55728002ne_sts
odists749852odists
peises84125042peises
pests75933272pe_sts
reests64618892reests
relists73817052relists
resists74414922resists
resits64725562resits
rests54935872re_sts
seises64026712seises
seisms84912142seisms
sexists14267672sexists
shists96515112shists
tests56530192te_sts
theists1039152theists
twists9549752twists
verists103613672verists
versts93914732versts
vests85325982ve_sts
waists97415452waists
wests85727002we_sts
whists124613812whists
wists86728522_wists
wrists95415642wrists
yeasts96413052yeasts
zests145419742ze_sts

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.343520965.0
2DLD Change Limit82551952.34635188.0
3Display Results95950.0303166.7
 (SQL Overall)178691952.71965719.4
 
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.