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

168 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
challah1545832(None) 
chalah143511651cha_lah
challa114014191challa_
challahs16377561challahs
challas124414121challas
hallah124115401_hallah
calla74827072c_alla_
callan83619602c_allan
callas84526752c_allas
chalahs15289882cha_lahs
chaleh143711992cha_leh
challie124012852challie
challis124613462challis
challot123613262challot
challoth16316102challoth
chally144314292chall_y
chaloth15298602chaloth
cholla113911022cholla_
chollas123811352chollas
halalah13429382_halalah
hallahs133912462_hallahs
hallal94415562_hallal
halvah15499832_halvah
wallah124011992_wallah
allay85620393__allay
almah106917253__almah
ballad94315323_ballad
calash11312433c_alash
calcar10312753c_alcar
caliph13311403c_aliph
call66838673c_all__
callans94518473c_allans
callant94121223c_allant
called94126733c_alled
callee84327293c_allee
caller85125483c_aller
callet84536763c_allet
callow114714663c_allow
calls75634733c_all_s
callus85317073c_allus
calpac123211063c_alpac
casbah1337903c_asbah
cavalla1257883cavalla_
cavallas1366843cavallas
cella75420313c_ella_
cellae84915933c_ellae
cellar84514983c_ellar
chablis14368553chablis
chacma1537903chacma_
chacmas1637993chacmas
chadar1239343cha_dar
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chakra15437533chakra_
chakras16428483chakras
chalaza2145733chalaza
chalazae2244423chalazae
chalazal2243873chalazal
chalazas2245893chalazas
chalcid1537873chalcid
chalehs15268803chalehs
chalet113825993cha_let
chalets122813473chalets
chalice14311043chalice
chalk144814603cha_l_k
chalked17449863chalked
chalks155412143cha_lks
chalky18468773cha_lky
challies133915633challies
chalone12312103chalone
chalot113020133cha_lot
chalupa1444473chalupa
chalupas1554383chalupas
chalutz2195083chalutz
champac1834953champac
champak2034493champak
chapeau1435523chapeau
chaplain1546193chaplain
chaplet14512253chaplet
chapman1637893chapman
charas114223593cha_ras
charka154011703charka_
charkas164810953charkas
charkha19405153charkha
charlady1743393charlady
charley15118273charley
charlie123011923charlie
charpai1436623charpai
chasmal14158213chasmal
chateau1236263chateau
chazan20269133cha_zan
chazzan20204853chazzan
cheetah1545453cheetah
chela103916803ch_ela_
chelae113614603ch_elae
chelas113817203ch_elas
chetah14399583ch_etah
chiliad1337563chiliad
chill105619873chill__
chilled133310933chilled
chiller124112183chiller
chilli114312773chill_i
chillis124411603chillis
chills114717703chill_s
chillum1435443chillum
chilly144113223chill_y
chimla1337593chimla_
chimlas1437453chimlas
chola104718033ch_ola_
cholas114817993ch_olas
chuddah17263253chuddah
chuppah1952453chuppah
coala77521123coa_la_
coalas87418963coa_las
collar83816173c_ollar
cullay113910173c_ullay
fallal93612693_fallal
fellah124910773_fellah
galah95917623_ga_lah
halakah17517953_halakah
halal85623593_ha_lal
halala94715093_halala
halalahs14367443_halalahs
halalas104214083_halalas
halals95018313_halals
halavah16447013_halavah
hall75741163_hall__
hallel93514093_hallel
hallo85127553_hall_o
halloa94918123_halloa
halloas104318463_halloas
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
halloth134111253_halloth
hallow124818323_hallow
halls85633783_hall_s
hallux1637363_hallux
hallway1636173_hallway
halma108219253_halma_
halmas117017893_halmas
halva115414433_halva_
halvahs16417533_halvahs
halvas124714173_halvas
hamzah23135553_hamzah
holla84918493_holla_
hollas94616903_hollas
lallan63414173_lallan
mollah11319453_mollah
mullah113710733_mullah
nullah9388143_nullah
phalli1148263phall_i
phallic1447293phallic
phallus1236063phallus
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shariah132210533shariah
shellac1236693shellac
thalli958913thall_i
thallic1246543thallic
thallus1035603thallus
walla85321033_walla_
wallahs13409473_wallahs
wallas95719393_wallas
zillah1836563_zillah

Search took 9 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 Limit1340271688.50015767.9
3Display Results1681680.0463652.2
 (SQL Overall)1786911688.70220534.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.