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 “cusps” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
cusps9491367(None) 
cups85430821cu_ps
cusks114916051cusks
cusp86021061cusp_
cuspis105010701cuspis
cuss65430611cus_s
asps65622092_asps
bumps115921142bumps
burps94220172burps
buses75936012buses
busks115521372busks
buss65134912bus_s
busts75227692busts
camps116330262camps
caps87147892c_aps
carps96932252carps
casas75327842casas
cases75048382cases
casks115720062casks
casts77237792casts
casus76419252casus
causes88026472causes
ceps86125952c_eps
cess65326052ces_s
chaps125326062chaps
chips125721252chips
chops125019872chops
chumps154313822chumps
cists76624532cists
claps95626182claps
clasps104512092clasps
clips96018302clips
clops95924852clops
clumps1215314642clumps
comps115526052comps
coops96229642coops
cops86751372c_ops
corps95927042corps
coses76949492coses
coss66143492cos_s
costs77231142costs
coups95522472coups
craps95328642craps
crisps104411512crisps
crops96125232crops
crumps124514342crumps
cruses88127712cruses
crusts84916542crusts
cubes95028162cubes
cubs85832382cu_bs
cuds76730472cu_ds
cues65438982cu_es
cuffs135017492cuffs
cuifs104814692cuifs
cukes115422092cukes
culls75425812culls
culms95314192culms
culpa93610962culpa
cults75022552cults
cunts76125122cunts
cup76738242cu_p_
cuppa11398522cuppa
cuppas12458592cuppas
cuppy144710382cuppy
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cu_rs
curses85328272curses
cuscus1038112cuscus
cusec94614902cusec
cusecs10509152cusecs
cushy134412322cushy
cusk105521632cus_k
cuspal1037882cuspal
cusped114312042cusped
cuspid11429212cuspid
cuspids12427112cuspids
cusses84522772cusses
cusso74912292cusso
cussos84210002cussos
custos84014312custos
cutes79438322cutes
cutis77723762cutis
cuts65841152cu_ts
cutups1036812cutups
cysts105912772cysts
dumps105220102dumps
dups75929512du_ps
dusks105317252dusks
dusts65923562dusts
fuses85628422fuses
fuss76027932fus_s
gasps85415482gasps
gulps84715072gulps
gusts65722792gusts
hasps105114642hasps
humps126322802humps
husks125015452husks
jumps165116492jumps
justs124918262justs
lisps76913912lisps
lumps95624982lumps
lusts55022802lusts
lusus54813872lusus
mumps115619102mumps
muses75134302muses
musks116119642musks
muss64933762mus_s
musts75527442musts
ousts55225702ousts
pulps95116482pulps
pumps115520602pumps
pups86032232pu_ps
puses75532202puses
puss64830132pus_s
quips164713372quips
rasps74316662rasps
rumps95922292rumps
ruses56136582ruses
rusks95816192rusks
rusts55026992rusts
sculps104611752sculps
scups95316652scu_ps
sumps95023432sumps
sups64834432su_ps
suss45229302sus_s
tumps95420792tumps
tups65628762tu_ps
turps74918732turps
tusks94915532tusks
umps85721942_umps
ups55629052_u_ps
urps66920482_urps
uses44931112_uses
wasps106714692wasps
wisps105214182wisps
wuss75219332wus_s
yups96121602yu_ps

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001431.60633499.4
3Display Results1431430.0334333.3
 (SQL Overall)1786911431.93592346.8
 
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.