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

144 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
chuppas164412(None) 
chuppa1543971chuppa_
chuppah1952451chuppah
chuppahs2042071chuppahs
cuppas12458591c_uppas
chufas14397672chu_fas
chukkas1532782chukkas
chumps154313822chump_s
chutzpas2451972chutzpas
cuppa11398522c_uppa_
huppah1644182_huppah
huppahs1743332_huppahs
capias10318353c_apias
chacmas1638003chacmas
chakras16428503chakras
challas124414123challas
chalupas1554383chalupas
champac1834953champac
champacs1934633champacs
champak2034493champak
champaks2134103champaks
champs154915683champ_s
chapeau1435523chapeau
chapeaus1544993chapeaus
chapels14429153chapels
chapes135421873ch_apes
chapman1637893chapman
chappati17124013chappati
chappatis18114013chappatis
chapped172711443chapped
chappie16298653chappie
chappies172610093chappies
chaps125326063ch_ap_s
charas114223613ch_aras
charkas164810963charkas
charpai1436633charpai
charpais1536933charpais
cheapos14418513cheapos
cheaps134613683cheap_s
cheeps135312913cheep_s
chelas113817203ch_elas
chias104625523ch__ias
chicas135916473ch_icas
chimlas1437453chimlas
chimps155713663chimp_s
chinas115119403ch_inas
chipped174110813chipped
chipper163912583chipper
chippers173510883chippers
chippie16297693chippie
chippies17309753chippies
chippy18437613chipp_y
chips125721253ch_ip_s
chirps135414003chirp_s
cholas114818003ch_olas
chollas123811353chollas
chomps155112223chomp_s
chopins142312243chopins
chopped174511003chopped
chopper163611893chopper
choppers174110463choppers
choppy18376293chopp_y
chops125019873ch_op_s
choreas124414203choreas
chromas142512693chromas
chubs125412623chu__bs
chucks174812933chu_cks
chuddah17263253chuddah
chuddahs18222583chuddahs
chuddar14263963chuddar
chuddars15253463chuddars
chufa13489113chu_fa_
chuffs17427783chu_ffs
chugs115511943chu__gs
chukar1534633chu_kar
chukars1634283chukars
chukka1433013chukka_
chukkar1542053chukkar
chukkars1642013chukkars
chump145315443chump__
chumped17379493chumped
chums125015833chu__ms
chunks154210333chu_nks
churls115411073chu_rls
churns114910233chu_rns
churros12427583churros
churrs115111513chu_rrs
chutes114615773chu_tes
chutzpa2361773chutzpa_
chutzpah2751413chutzpah
chutzpahs2851093chutzpahs
clumps1215314643clump_s
compas125817063c_ompas
coppras13327833coppras
copras103517153c_opras
copulas113811563copulas
coupes105022523cou_pes
couples115317053couples
coupons112710563coupons
coups95522473cou_p_s
cowpeas1437273cowpeas
crumps124514343crump_s
crupper13338563crupper
cruppers14317323cruppers
culpa93610963c_ulpa_
culpae10389263c_ulpae
cupels10310203c_upels
cupids11369193c_upids
cupolas11277753c_upolas
cupped134413983c_upped
cupper124313863c_upper
cuppers133712213c_uppers
cuppy144710383c_upp_y
cups85430823c_u_p_s
cuspal1037883c_uspal
cuspis105010703c_uspis
cusps94913673c_usp_s
cutlas8313103c_utlas
dhurnas1153443dhurnas
grappas12357103grappas
hippos13408433_hippos
hulas84920883_hu_las
humphs16528163_humphs
humps126322803_hump_s
hutzpas2142693_hutzpas
huzzas1735863_huzzas
kappas144410363_kappas
koppas14407603_koppas
nappas105511613_nappas
poppas93710713_poppas
pupas95219283_pu_pas
rhumbas14305163rhumbas
schappes1736033schappes
sherpas1238093sherpas
shoppes143411393shoppes
stupas83910883stu_pas
thujas1634433thu_jas
thulias1035743thulias
thumps13449353thump_s
thuyas1234773thu_yas
upas68322383__u_pas
whumps16427093whump_s
whupped18365413whupped
whups134210003whu_p_s

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.406440125.6
2DLD Change Limit1340271446.17321711.8
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.62526972.2
 
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.