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

74 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
afghans144357(None) 
afghan1333871afghan_
afghani1442531afghani
afghanis1542861afghanis
aghas97014872a_gha_s
ataghans1244262ataghans
afars85716513af__ars
affiant1348433affiant
affiants1445233affiants
affrays1644063affrays
agars66120643a_g_ars
agas55938843a_g_a_s
agha87417303a_gha__
aghast105711373a_ghast
agmas85919873a_gma_s
agons66423783a_g_ons
ajowans1734003ajowans
alans55636173a__lans
algas65624933alg_a_s
algins74816433alg_ins
alohas9411703aloha_s
alphas1139513alpha_s
angas65827983ang_a_s
anginas8310953anginas
anurans73810553anurans
archons12311583archons
argals75517713arg_als
argons75018203arg_ons
arhats9312973a_rhats
arshins10312573arshins
ashcans1235183ashcans
ataghan1144653ataghan_
atamans9710433atamans
atmans84413963a_tmans
aughts104710243augh_ts
avgas96912133avg_a_s
avians93711563a_vians
azans146516883a__zans
barchans1588683barchans
bogans95714813bog_ans
caftans12179443caf_tans
darshans1286543darshans
fagins10513863fag_ins
fans76247373_f__ans
flans85327973_f_lans
fohns117310783_foh_ns
furans94515953_furans
ghats95818613__ghats
glans65125833__glans
grans64832543__grans
guans64419443__guans
hogans105914313hog_ans
kaftans14185353kaf_tans
khans124615173__khans
lagans75717783lag_ans
langshans1344283langshans
ligans76817733lig_ans
lignans8398853lignans
lochans1248833lochans
logans76319063log_ans
magians10310753magians
mughals1355763mughals
offhand1742883offhand
oghams1245853_oghams
organs7912913org_ans
orphans1237773orphans
pagans95717923pag_ans
pechans14810503pechans
raglans82410133raglans
vegans103910853veg_ans
wangans1149503wang_ans
wigans104511703wig_ans
xanthans1845693xanthans
yataghans1651903yataghans

Search took 6 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027745.72023431.3
3Display Results74740.0302466.7
 (SQL Overall)178691745.90630255.8
 
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.