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

248 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
chazans2126812(None) 
chazan20269131chazan_
chazzans21234501chazzans
hazans183411651_hazans
azans146516882__azans
chadars1338292chadars
chains114819702cha_ins
chalahs15289882chalahs
charas114223612chara_s
chazanim24123512chazanim
chazzan20204852chazzan_
chazzens21253942chazzens
hazan173813612_hazan_
hazzans18215782_hazzans
khazens2332662khazens
shamans123610902shamans
alans55636173__alans
amazons1836653amazons
archaeans14134143archaeans
atamans9710433atamans
azan136521783__azan_
azons146518253__azons
bazars174613113_bazars
bharals1236733bharals
blazons1836163blazons
brazas175812433braza_s
brazens18418713brazens
cabals104020153c_abals
cabana103913563c_abana
cabanas112413033c_abanas
cabins104418923c_abins
cacaos104616183c_acaos
cacas95627983c_aca_s
caftans12179443caftans
caimans113811783caimans
cains75334303c_a_ins
cairns85313303c_airns
callans94518473callans
camas96333523c_ama_s
camass104114183c_amass
canals84421673c_anals
cancans11311873cancans
cannas84518403c_annas
canons85522063c_anons
cans65050853c___ans
capons104119503c_apons
captans111612053captans
carats85929023c_arats
caravans1338623caravans
carns75937563c_a_rns
casas75327843c_asa_s
caymans14349513caymans
chablis14368563chablis
chabuks1843733chabuks
chacmas1638003chacmas
chadar1239353chada_r
chadors1338753chadors
chads116122233ch__ads
chafers154512743chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chafing163911493chafing
chagrins1437073chagrins
chain105723673cha_in_
chaine115119223cha_ine
chaines124518733chaines
chairmans1685143chairmans
chairs114916183cha_irs
chais107530313ch__ais
chaises124317493chaises
chakras16428503chakras
chalah143511663chala_h
chalaza2145733chalaza
chalazas2245893chalazas
chalehs15268803chalehs
chalets122813473chalets
chalks155412143cha_lks
challahs16377563challahs
challas124414123challas
challis124613463challis
chalone12312103chalone
chalones13312173chalones
chamade15138453chamade
chamades16138653chamades
chamois143512193chamois
champacs1934633champacs
champaks2134103champaks
champs154915683cha_mps
chams126028503ch__ams
chances145218093chances
chang115418563ch__ang
changes134517583changes
changs125215373cha_ngs
chansons1337473chansons
chant105932693ch__ant
chants115020393cha_nts
chaos105622863ch__aos
chaoses124715123chaoses
chapati14118023chapati
chapatis15127943chapatis
chapeaus1544993chapeaus
chapels14429153chapels
chapes135421873cha_pes
chaplains1645743chaplains
chapman1637893chapman_
chaps125326063ch__aps
characins1647593characins
charade13129913charade
charades141310853charades
charases131312763charases
chards125119733cha_rds
chares115631803cha_res
charges134615983charges
charing133721323charing
charkas164810963charkas
charks155219703cha_rks
charms135218843cha_rms
charpais1536933charpais
charros124312153charros
charrs115219193cha_rrs
chars105936643ch__ars
charts115823093cha_rts
chasers123714923chasers
chases115128233cha_ses
chasing133715893chasing
chasings14318253chasings
chasms135513143cha_sms
chasses124017503chasses
chassis123910663chassis
chastens13429183chastens
chateaus1346013chateaus
chats105730093ch__ats
chaunt11613493cha_unt
chaunts1267083chaunts
chawers154412053chawers
chawing164813033chawing
chaws135022463ch__aws
chays135319743ch__ays
chazzanim2451673chazzanim
chazzen20214783chazzen
cheapens15305943cheapens
cheaps134613683ch_eaps
cheats114519543ch_eats
chelas113817203chela_s
chetahs15347073chetahs
chias104625523ch_ia_s
chiaus113611313ch_iaus
chicane1489553chicane
chicanes1559373chicanes
chicano1496873chicano
chicanos1595993chicanos
chicas135916473chica_s
chimars144010593chimars
chinas115119403china_s
chins105631463ch__ins
chitins122713793chitins
chitons122611913chitons
choana1138443ch_oana
cholas114818003chola_s
chopins142312243chopins
chorals124614113chorals
chufas14397673chufa_s
chukars1634283chukars
churns114910233ch_urns
clachans1546413clachans
clamant11312433clamant
clans75031013c__lans
claxons1635803claxons
claypans1543873claypans
cleans85817053c_leans
coalas87418963coala_s
colzas174010513colza_s
corbans11313173corbans
cotans81317923c_otans
cozens176314923c_ozens
craals84113303cra_als
cratons94316033cratons
cravats1237403cravats
cravens124010123cravens
crayons12439233crayons
crazes174720133craz_es
crazies183413853crazies
crazing193914583crazing
currans9310613currans
cyanins122910013cyanins
cyans105714813c__yans
czars164812913c__zars
damans94715983_damans
dharnas1155373dharnas
diazins1739183diazins
gazars164811553_gazars
ghazies2036913ghazies
ghazis1935203ghaz_is
haafs115711163_ha_afs
haars85620473_ha_ars
hahas117118443_haha_s
halals95018313_halals
halons95720713_halons
hamals114816833_hamals
hamzahs24134373_hamzahs
hamzas20119013_hamza_s
harass9313943_harass
havens124514043_havens
hazanim2164623_hazanim
hazard1938403_hazard
hazards2037463_hazards
hazels185710083_hazels
hazers184615953_hazers
hazes174928323_haz_es
hazing194218553_hazing
hazings20378343_hazings
hazmats2136603_hazmats
hazzan17236803_hazzan_
hogans105914313_hogans
honans94814503_honans
humans112312433_humans
japans1539823_japans
jawans1657843_jawans
khans124615173kh__ans
khazen2233773khazen_
lagans75717783_lagans
lauans65113533_lauans
lazars153812393_lazars
naans55815253_na_ans
paeans85118263_paeans
pagans95717923_pagans
pavans115715593_pavans
phalanx1945203phalanx
platans93413123platans
plazas17409913plaza_s
ratans63819373_ratans
rhatany1353693rhatany
sarans64224433_sarans
seawans10379943seawans
shairns10276783shairns
shaitans1136413shaitans
shaman113314283shaman_
shamas113717943shama_s
sharns95516983sha_rns
shazam2046623shaza_m
shorans102812413shorans
tarzans16329923tarzans
thiazins2045313thiazins
trapans92812463trapans
uhlans937573uh_lans
weazand2043613weazand
weazands2143333weazands
zazens1435833_zazens

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.390458182.1
2DLD Change Limit1340272486.37621020.5
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.85926052.0
 
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.