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

149 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
catsups113534(None) 
catsup1036431catsup_
casus76419252ca_su_s
catchups1744382catchups
catguts1045322catguts
catnaps1197032catnaps
catnips1195892catnips
catsuit959392catsuit
catsuits1045432catsuits
cutups1036812cut_ups
asps65622093_a_s_ps
ataps76414833_at_aps
backups1736173backups
battues94610193battues
cactus104912233cactu_s
cactuses1237933cactuses
caesars9410733caesars
caesiums1245533caesiums
caestus947773caestus
caesura956233caesura
caesuras1055733caesuras
caiques18248793caiques
callus85317073callu_s
calques182710193calques
caltraps12327253caltraps
caltrops12307863caltrops
camps116330263ca__mps
campus125213923campu_s
canfuls1248423canfuls
cangues10611823cangues
cansos84915383cans_os
canthus1248713canthu_s
cantraps12319113cantraps
cantrips12318933cantrips
cantus85117763cantu_s
capfuls1436523capfuls
caps87147893ca___ps
capsids1239333capsids
capsule1137343capsule
capsules1236623capsules
carfuls1249133carfuls
carhops14329703carhops
carps96932253ca__rps
carpus105514303carpu_s
carses85233653cars_es
casas75327843ca_s_as
cases75048383ca_s_es
cashes114729883ca_shes
casks115720063ca_s_ks
casques18278983casques
cassias93514343cassias
cassis84818853ca_ssis
casters94729903casters
castes85631863ca_stes
castles94917733castles
castors94919443castors
casts77237793ca_s_ts
casual81112863ca_sual
casuals91410523ca_suals
casuist9411303ca_suist
catalos9414163catalos
catalpa1136503catalpa
catalpas1246733catalpas
catches144320773catches
catchup1644793catchup_
catenas9313113catenas
caters85336503cat_ers
cates75951893cat__es
catgut9310803catgu_t
cations94524143cations
catkins133012563catkins
catlins93818843catlins
catnap1098383catnap_
catnip1097973catnip_
cats66356343cat___s
catspaw1443353catspaw
catspaws1543163catspaws
catties94023053catties
caucus1039613caucu_s
cauls75727773ca__uls
causals91411183causals
causers94014793causers
causes88026473caus_es
causeys12387223causeys
cayuses12188403cayuses
census84310303censu_s
cestus84412913cestu_s
cistus84611343cistu_s
citrus83610923citru_s
clasps104512093clas_ps
closeups12102803closeups
cockups1735223cockups
consuls92412313consuls
coups95522473c__oups
crackups1843123crackups
crisps104411513cris_ps
croups104312553c_roups
cups85430823c___ups
cusps94913673c_us_ps
cutouts938033cutouts
cutup9410093cut_up_
datums936353dat_ums
dustups1033913dustups
fatsoes10379423fatsoes
fatsos9389423fats_os
gasps85415483ga_s_ps
getups9346853get_ups
hangups1364813hangups
hasps105114643ha_s_ps
hatfuls1386023hatfuls
jaups144810533ja__ups
katsura1143753katsura
katsuras1243653katsuras
lapsus8437273lapsu_s
larrups934733larrups
layups1133993la_yups
letups8317683let_ups
makeups1533603makeups
markups1534963markups
matchups1743073matchups
matsahs1236563matsahs
passus83610293passu_s
pasteups1243493pasteups
patsies93919483patsies
rasps74316663ra_s_ps
sannups934463sannups
satraps95011643satraps
satsuma943873satsuma
satsumas1043573satsumas
scaleups1243393scaleups
scaups105411933sca__ups
setups83910463set_ups
situps8538783sit_ups
stoups85313273_stoups
sups64834433___sups
takeups1333403takeups
tarsus6310513tarsu_s
tatsois748373tatsois
tittups933353tittups
tossups964023tossups
tups65628763__t_ups
vatfuls1384853vatfuls
vatus86114643vat_u_s
walkups1633013walkups
warmups1433813warmups
washups1534683washups
wasps106714693wa_s_ps
wataps11248683wat_aps
yaups105910743ya__ups

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.403443402.0
2DLD Change Limit1340271496.20621596.4
3Display Results1491490.0602483.3
 (SQL Overall)1786911496.66926794.3
 
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.