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

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

154 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
hazzans1821578(None) 
chazzans21234501chazzans
hazans183411651ha_zans
hazzan17236801hazzan_
azans146516882_a_zans
chazans21268122cha_zans
chazzan20204852chazzan_
chazzens21253942chazzens
hamzahs24134372hamzahs
hamzas20119012hamza_s
hazan173813612ha_zan_
hazmats2136602hazmats
hazzanim2142142hazzanim
huzzahs2143082huzzahs
huzzas1735862huzza_s
tarzans16329922tarzans
tazzas1436272tazza_s
alans55636173_a_lans
atmans84413963_atmans
avians93711563_avians
azan136521783_a_zan_
azlons154110423_azlons
azons146518253_a_zons
baizas173810823baiza_s
banians9312033banians
banyans1237913banyans
banzais1837163banzais
bazaars18275883bazaars
bazars174613113ba_zars
bezzant1746893bezzant
bezzants1843643bezzants
caftans12179443caftans
caimans113811783caimans
callans94518473callans
cancans11311873cancans
captans111612053captans
caymans14349513caymans
chazan20269133cha_zan_
chazzanim2451673chazzanim
chazzen20214783chazzen_
damans94715983da_mans
dazzles1636413dazzles
gazars164811553ga_zars
haafs115711163ha__afs
haars85620473ha__ars
habitans1346623habitans
hadrons113314303hadrons
haemins122811393haemins
hagdons1258523hagdons
hahas117118443ha_ha_s
halals95018313ha_lals
hallahs133912463hallahs
halmas117017893halma_s
halons95720713ha_lons
halvahs16417533halvahs
halvas124714173halva_s
hamals114816813ha_mals
hammals14409213hammals
hammams13386433hammams
hamza19139773hamza__
hamzah23135553hamza_h
hangars114313483hangars
hansas94616043hansa_s
hanumans1344943hanumans
happens14359173happens
haptens124511343haptens
harass9313943ha_rass
hardass1139753hardass
hardens113815023hardens
hardpans1436453hardpans
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
harkens144112863harkens
harmins123716713harmins
harpins123615703harpins
hartals10313023hartals
hastens106214813hastens
hatband1346823hatband
hatbands1446283hatbands
hatpins123410643hatpins
hausens1077633hausens
havens124514043ha_vens
hazanim2164603ha_zanim
hazard1938403ha_zard
hazards2037463hazards
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_z_es
hazing194218553ha_zing
hazings20378343hazings
hazmat20312263hazma_t
hetmans12187593hetmans
hoatzins2043833hoatzins
hogans105914313h_ogans
honans94814503h_onans
humans112312433h_umans
huzza1646093huzza__
huzzaed1943103huzzaed
huzzah2044423huzza_h
huzzaing2042433huzzaing
japans1539823ja_pans
jawans1657843ja_wans
jazzbos2442033jazzbos
jazzers22324763jazzers
jazzes21347883jazz_es
jazzing2333883jazzing
jazzman2442553jazzman_
kaftans14185353kaftans
kalians11310183kalians
kanbans1337723kanbans
khazens2332663kha_zens
lagans75717783la_gans
lallans74113533lallans
lauans65113533la_uans
lazars153812393la_zars
magians10310753magians
mannans93611523mannans
matzahs2134483matzahs
matzas1749703matza_s
mazzard1844463mazzard
mazzards1943943mazzards
mizzens17366123mizzens
naans55815253na__ans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
parians93519733parians
partans94418283partans
pavans115715593pa_vans
piazzas1743643piazza_s
pizzas1646983pizza_s
radians83013823radians
raglans82410133raglans
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
razzes144910063razz_es
razzing1636323razzing
sampans112411003sampans
sarans64224433sa_rans
shaitans1136403shaitans
shamans123610893sha_mans
taipans9269553taipans
tampans113310983tampans
tarpans92513533tarpans
tartans72615823tartans
tarzan152910753tarzan_
tazza1338083tazza__
wangans1149503wangans
wizzens18385483wizzens
zanzas1487053zanza_s
zazens1435833za_zens

Search took 7 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 Limit1340271546.73319906.0
3Display Results1541540.0632444.4
 (SQL Overall)1786911546.95225703.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.