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

155 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
catguts104532(None) 
catgut9310801catgut_
cangues10611822cangues
catsuits1045432catsuits
catsups1135342catsups
cutouts938032cutouts
rotguts833762rotguts
abuts75417073_a_buts
agues64919053_a_gues
algums9208043_algums
angsts738863_angsts
argots74116033_argots
argues74516413_argues
argus66716543_argu_s
aughts104710243_aughts
augurs7399963_augurs
august739203_august
baguets1037483ba_guets
barbuts11439843barbuts
batts76727563bat__ts
battues94610193battues
bututs8409423but_uts
cablets114216343cablets
cachets145014263cachets
cactus104912233cactu_s
cadets96316513ca_dets
cadgers114712003cadgers
cadges104716713cadg_es
caestus947773caestus
cagers95624193ca_gers
cages85936013ca_g_es
cahoots1238473cahoots
caiques18248793caiques
cajaputs1942663cajaputs
cajeputs1942803cajeputs
cajuputs1941793cajuputs
callets93821703callets
callus85317073callu_s
calques182710193calques
camlets114314623camlets
campouts1436823campouts
campus125213923campu_s
canfuls1248423canfuls
cangue91012443cangu_e
canthus1248713canthu_s
cants77036943ca__nts
cantus85117763cantu_s
capfuls1436523capfuls
caplets114914523caplets
caput9823983ca_put_
carats85929023ca_rats
carets85330773ca_rets
carfuls1249133carfuls
cargoes104415223cargoes
cargos94619183carg_os
carnets93918403carnets
carpets113915333carpets
carpus105514303carpu_s
carrots9714623carrots
carts78946293ca__rts
caskets133910173caskets
casques18278983casques
casts77237793ca__sts
casus76419253ca_su_s
catalos9414163catalos
catapults1342953catapults
catboats1247873catboats
catches144320773catches
catchups1744383catchups
catenas9313113catenas
caters85336503cat_ers
cates75951893cat__es
catfights1842793catfights
cathects1545793cathects
cations94524143cations
catkins133012563catkins
catlins93818843catlins
catmints1236663catmints
catnaps1197033catnaps
catnips1195893catnips
cats66356343ca___ts
catsuit959393catsuit
catsup1036433catsu_p
catties94023053catties
catty104520413cat__ty
caucus1039613caucu_s
caught124911683caught_
cauls75727773ca__uls
caveats1239803caveats
cavorts1237933cavorts
citrus83610923citru_s
claughts1443383claughts
clouts87017203c_louts
cobnuts1135353cobnuts
copouts11311083copouts
cutlets94113653cutlets
cutout8315923cutout_
cuts65841153c___uts
cutups1036813cut_ups
datums936353dat_ums
dauts67822243da__uts
faggots1234863faggots
fagots1039963fa_gots
fatigues1244193fatigues
gadgets10348683gadgets
gamuts958783ga_muts
gangues9149753gangues
gargets94614573gargets
guts56637253___guts
hagbuts1354933hagbuts
hangouts1236183hangouts
hangups1364813hangups
hatfuls1386023hatfuls
kagus105812033ka_gu_s
langues81211913langues
languets987243languets
langurs889103langurs
latents75214313latents
latests73910313latests
layouts1046483layouts
maggots1136563maggots
magots9312363ma_gots
magus85318753ma_gu_s
mahouts1237143mahouts
matts76829183mat__ts
mauts75927193ma__uts
midguts11296013midguts
naughts11447513naughts
outguns8318693outguns
outjuts1476493outjuts
outputs988493outputs
pargets105215193pargets
patents94815203patents
payouts1247303payouts
putouts937083putouts
ragouts838543ragouts
rotgut738793rotgut_
sacbuts1166473sacbuts
sagbuts1065223sagbuts
scatts85914663scat__ts
setouts74110333setouts
stouts65019003_stouts
struts65616803_struts
targets84314223targets
tauts56125513__tauts
touts54830393__touts
tuts45838453__t_uts
vagus96713813va_gu_s
valgus1047103valgu_s
vatfuls1384853vatfuls
vatus86114643vat_u_s
walnuts1033843walnuts
wanguns1135023wanguns
watts86923093wat__ts
waughts14355963waughts

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 Limit1340271556.14321817.8
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.60927037.5
 
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.