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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
azans14651688(None) 
alans55636171alans
azan136521781azan_
azons146518251azons
hazans183411651hazans
aahs716428562a_ahs
aals49941142a_als
aas310975392a_a_s
abas68642082aba_s
aeons57624652aeons
afars85716512afars
agars66120642agars
agas55938842aga_s
agons66423782agons
ains46158882a_ins
airns55521032airns
alan46844082alan_
aland65526412aland
alands75418372alands
alane56135612alane
alang66023512alang
alant55742292alant
alants67722022alants
alas46358122ala_s
amahs107819062amahs
amas67746292ama_s
amass77119682amass
amens75624842amens
amins75534322amins
anas46649862ana_s
annas55824882annas
araks94820882araks
asana5315482asana
asanas6514112asanas
ataps76414832ataps
atmans84413962atmans
avant86224662avant
avens86419332avens
avians93711562avians
awns75324432a_wns
axons125517932axons
ayahs116813522ayahs
ayins85321612ayins
azine146721412azine
azines155517072azines
azlons154110422azlons
azon135725052azon_
bans66555142_bans
bazars174613112bazars
beans75734692beans
brans75437432brans
cans65050852_cans
chazans21268122chazans
clans75031012clans
cyans105714812cyans
czars164812912czars
damans94715982damans
dans56748152_dans
deans66131392deans
elans55527752elans
fans76247372_fans
flans85327972flans
gazars164811552gazars
glans65125832glans
grans64832542grans
guans64419442guans
hazan173813612hazan_
hazzans18215782hazzans
izars145112932izars
japans1539822japans
jawans1657842jawans
jeans126022112jeans
khans124615172khans
koans95818622koans
lagans75717782lagans
lauans65113532lauans
lazars153812392lazars
leans55536252leans
loans56026462loans
mans66354552_mans
means75831232means
moans74624372moans
naans55815252naans
nans46139402_nans
paeans85118262paeans
pagans95717922pagans
pans65855732_pans
pavans115715592pavans
peans75437642peans
pians75126962pians
plans75731272plans
ratans63819372ratans
roans54926442roans
sans45153362_sans
sarans64224432sarans
scans74625102scans
spans74528732spans
swans84625012swans
tans46154822_tans
tarzans16329922tarzans
trans54933042trans
tzars144914272tzars
ulans54921302ulans
vans76236732_vans
wans76452272_wans
weans85326742weans
yeans86624882yeans
yuans84613322yuans
zags146826682_zags
zany167316992_zany
zaps156826892_zaps
zas126946832_za_s
zazens1435832zazens
zins135735002_zins

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 Filter178691538000.326548131.9
2DLD Change Limit538001141.67332157.8
3Display Results1141140.0303800.0
 (SQL Overall)1786911142.02988068.5
 
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.