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

135 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
cuscuses123586(None) 
caucuses1236782caucuses
cestuses1038082cestuses
circuses1238252circuses
cistuses1038282cistuses
couscouses1443912couscouses
crocuses1239022crocuses
cultuses1037752cultuses
cuscus1038112cuscu__s
cusses84522772cus__ses
discuses113112862discuses
fucuses12158352fu_cuses
lususes736712lus_uses
mucuses11148512mu_cuses
abacuses1235763abacuses
abscises1246233abscises
accuses114112193_accuses
arcuses94814693_arcuses
asceses938623_asceses
bascules1236683bascules
busses85023383bus__ses
byssuses1342273byssuses
cactuses1237933cactuses
caestuses1144893caestuses
calluses1039323calluses
campuses1437773campuses
carcases12313093carcases
carouses10614503carouses
cascades13128553cascades
caseases10410473caseases
caseoses1039293caseoses
casques18278983casqu_es
cassises103811743cassises
caucused1344093caucused
caucusses1343043caucusses
causes88026473c__auses
cayuses12188403c_ayuses
censuses10187543censuses
cercises12410933cercises
cereuses1049243cereuses
ceruses93716233c_eruses
cesses84221363ces__ses
chiauses1336483chiauses
choruses1339983choruses
chouses125117813c_houses
ciscoes113610733cisc_oes
citruses1037483citruses
clauses93813323c_lauses
clonuses1057133clonuses
coituses1039623coituses
coleuses1039723coleuses
concuss1138063concus_s
concusses1346343concusses
confuses13310363confuses
contuses10413453contuses
cornuses10310033cornuses
corpuses12310063corpuses
cosmoses1239703cosmoses
costumes1258013costumes
cruses88127713c__ruses
cuisses9319883cu_isses
culches143710743culc_hes
cullises103111313cullises
cultures10310153cultures
cupcakes1843713cupcakes
cupules113210263cu_pules
curches143512743curc_hes
curcumas1454853curcumas
curses85328273cu__rses
cuspides13306943cuspides
cussed94917123cus__sed
cusser86016093cus__ser
cussers94213403cus__sers
cussos84210003cus__sos
custodes1136653custodes
cutches143216463cutc_hes
cutises94414913cu_tises
cutlases1038033cutlases
cutpurses1343313cutpurses
cycases1437533c_ycases
cypruses1534313cypruses
discases112014503discases
discuss10357953discus_s
discusses12268253discusses
diseuses93112763diseuses
disuses84015413dis_uses
dufuses11436593du_fuses
excuses1638903_excuses
fescues1236783fescu_es
ficuses12159203_ficuses
focuses12159653_focuses
fucoses12148303fu_coses
funguses1254713funguses
fusses94920553fus__ses
hocuses121710423_hocuses
hummuses1544453hummuses
humuses1237593hu_muses
incuses93514853_incuses
lupuses936273lu_puses
miscues11312393miscu_es
missuses10309683missuses
misuses93216023mis_uses
muscles11310563musc_les
musses84624783mus__ses
nutcases1085793nutcases
obscures1245513obscures
opuscules1342753opuscules
oscules938123_oscules
outcurses1145803outcurses
passuses1036773passuses
pusses84322843pus__ses
pustules1038443pustules
recuses94619463_recuses
rescues9312753rescu_es
risuses73210923ris_uses
ruckuses1444913ruckuses
rumpuses1235163rumpuses
scouses93313243__scouses
scutes85219193__scutes
souses64229243__souses
subcauses1346213subcauses
subcutes1238583subcutes
succuss1134993succus_s
succusses1344423succusses
suffuses1435833suffuses
susses64221053sus__ses
tusches1237903tusc_hes
tusses64921243tus__ses
tussises835433tussises
uncases93516553_uncases
uruses63616503_u_ruses
usques15126803_usqu_es
viscoses1338343viscoses
vulguses1243503vulguses
wusses93314893wus__ses

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621357.48619524.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.96822426.1
 
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.