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

269 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
craps9532864(None) 
caps87147891c_aps
carps96932251carps
chaps125326061chaps
claps95626181claps
crabs95421391crabs
crags85622571crags
cramps125615561cramps
crams96229151crams
crap85731841crap_
crape96128441crape
crapes104727691crapes
crass76328041crass
craws105723121craws
crops96125231crops
fraps105620551fraps
raps66247731_raps
scraps106017241scraps
traps75727481traps
wraps105617151wraps
araks94820882araks
ataps76414832ataps
baps86040842_baps
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
cabs86739422c_abs
cads76144522c_ads
camps116330262camps
cams87047282c_ams
cans65050852c_ans
cap76758982c_ap_
cape87242782c_ape
capes95441922c_apes
caph116623292c_aph
caphs124515372c_aphs
capo85829212c_apo
capos94826072c_apos
carats85929022carats
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carp85139812carp_
carpi94319392carpi
carpus105514302carpus
carrs75730852carrs
cars67364762c_ars
carts78946292carts
cats66356342c_ats
caws96036112c_aws
cays95437672c_ays
ceps86125952c_eps
chads116122232chads
chais107530312chais
champs154915682champs
chams126028502chams
chaos105622862chaos
chap114928492chap_
chape125221142chape
chapes135421872chapes
chapt125827642chapt
chars105936642chars
chats105730092chats
chaws135022462chaws
chays135319742chays
cheaps134613682cheaps
chips125721252chips
chops125019872chops
clads85722732clads
clags85621122clags
clamps124515082clamps
clams95127672clams
clans75031012clans
clap86429042clap_
clapt98027172clapt
clasp95517192clasp
clasps104512092clasps
class75525482class
claws106020832claws
clays105521332clays
clips96018302clips
clops95924852clops
coals76129602coals
coapt96131532coapt
coapts104614012coapts
coats75635002coats
comps115526052comps
coops96229642coops
cops86751372c_ops
corals85325142corals
corps95927042corps
coups95522472coups
craal74117752craal
craals84113302craals
crab85727672cra_b
crack134120532crack
cracks144817002cracks
craft105327662craft
crafts115312742crafts
crag75625302cra_g
crake114823522crake
crakes124921812crakes
cram85635492cra_m
cramp115120692cramp
crampy154710992crampy
crane75331602crane
cranes84330752cranes
crank114819612crank
cranks125015312cranks
craped116120522craped
crappy15446802crappy
crases85532312crases
crash109120012crash
crasis85020472crasis
crate76537402crate
crates85736062crates
crave105626312crave
craves115825392craves
craw97725262cra_w
crawl104916712crawl
crawls114712082crawls
craze165221462craze
crazes174720132crazes
crazy195511222crazy
creaks124315962creaks
creams104715252creams
creds85418772creds
creeps104213622creeps
crepe95520722crepe
crepes105419342crepes
crept95125892crept
crepy124812702crepy
cress75022832cress
crews105917502crews
cribs94516752cribs
cries75438402cries
crimps124613452crimps
cripe95521142cripe
cripes105120872cripes
cris66233432cr_is
crisp95014622crisp
crisps104411512crisps
crits75527572crits
croaks125812982croaks
crocs95722432crocs
crop87628632crop_
cross75124502cross
croups104312552croups
crows105727312crows
cruds85815852cruds
crumps124514342crumps
crus65828482cr_us
crypt123715232crypt
crypts13397742crypts
cups85430822c_ups
cusps94913672cusps
cyans105714812cyans
czars164812912czars
daps77239162_daps
drabs85119672drabs
drags75521112drags
drams86025832drams
drape85319632drape
drapes95419652drapes
drats66628372drats
draws95119372draws
drays95819772drays
drips85417232drips
drops85719502drops
eras45441502era_s
flaps105621382flaps
frags96322172frags
frap95925812frap_
frass85321122frass
frats86829672frats
frays116920102frays
gaps76042972_gaps
grabs85719692grabs
grads75625752grads
gramps114114272gramps
grams85327312grams
grans64832542grans
grape84824662grape
grapes95123122grapes
graph115315612graph
graphs124510152graphs
grapy115416432grapy
grasp84814482grasp
grasps9489252grasps
grass66125202grass
grays95621332grays
grips85520132grips
haps96443462_haps
harps105926872harps
heaps105223222heaps
knaps115511172knaps
laps66848872_laps
leaps75522932leaps
maps86141052_maps
naps66238582_naps
neaps75618322neaps
orals55826482orals
paps86443452_paps
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
preps96220692preps
props95726882props
rads56046602_rads
rags55448372_rags
rais45252622_rais
ramps96224632_ramps
rams65950772_rams
rap56261962_rap_
rape65041632_rape
rapes75740722_rapes
rapt67245312_rapt
ras37575392_ra_s
rasp66029162_rasp
rasps74316662_rasps
rats46260372_rats
raws75238212_raws
rays77642352_rays
reaps75626192reaps
reps65937952_reps
rips66237432_rips
saps65346372_saps
scarps104718602scarps
scrags95713802scrags
scrams105216622scrams
scrap97120402scrap_
scrape105917572scrape
scrapes116217662scrapes
scrips105316032scrips
slaps76025712slaps
snaps74719562snaps
soaps75120712soaps
straps87721782straps
swaps104819202swaps
taps66050672_taps
tarps76527112tarps
tramps105114452tramps
trams75327672trams
trans54933042trans
trap67532802trap_
trapes85024462trapes
trapt76433392trapt
trass56226472trass
trays85623432trays
trips74923362trips
urps66920482ur_ps
waps96642082_waps
warps107126422warps
whaps135115162whaps
wrap96821972wrap_
wrapt105123182wrapt
yaps95933522_yaps
zaps156826892_zaps

Search took 3 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.310576422.6
2DLD Change Limit538002691.75030742.9
3Display Results2692690.0803362.5
 (SQL Overall)1786912692.14083500.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.