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

274 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
crases8553231(None) 
carses85233651carses
cases75048381c_ases
ceases84427071ceases
chases115128231chases
crakes124921811crakes
cranes84330751cranes
crapes104727691crapes
crashes124618401crashes
crasis85020471crasis
crass76328041cras_s
crates85736051crates
craves115825391craves
crazes174720131crazes
creases94020961creases
crises84529431crises
cruses88127711cruses
erases64425401erases
prases84429021prases
rases55447211_rases
urases63723561urases
abases85720772abases
arames84622572arames
arises65233802arises
arrases71214542arrases
arses55733872ar_ses
baases85218012baases
bases75644352_bases
biases84618432biases
braces108427772braces
braes75735052bra_es
braises93818872braises
brakes124923122brakes
brashes124518462brashes
brass75428022bras_s
brasses93818352brasses
braves115524082braves
brazes175522192brazes
brises84927612brises
broses86524402broses
cades85440732c_ades
cafes106426922c_afes
cages85936012c_ages
cakes116037672c_akes
camases114216342camases
cames97047312c_ames
canes75350372c_anes
capes95441922c_apes
carafes125015702carafes
carates95630602carates
carcases12313082carcases
cares77369182c_ares
caress85720262caress
caries85147622caries
carles85435082carles
carse74934332carse_
cartes86239472cartes
carves115128452carves
casas75327842c_asas
case65848082c_ase_
cased86032412c_ased
cashes114729882c_ashes
casks115720062c_asks
castes85631862c_astes
casts77237792c_asts
casus76419252c_asus
cates75951872c_ates
causes88026472causes
caves105639702c_aves
cease75227652cease_
ceased94920782ceased
censes83721802censes
cerastes101111092cerastes
cerates95428232cerates
cerises94722252cerises
ceruses93716232ceruses
cesses84221362cesses
chafes145017912chafes
chaises124317492chaises
chaoses124715112chaoses
chapes135421872chapes
charases131312752charases
chares115631802chares
chase105127122chase_
chased125019292chased
chaser114918382chaser
chasers123714892chasers
chasms135513142chasms
chasse115114602chasse
chasses124017502chasses
choses115825122choses
clades94920462clades
clashes124017282clashes
clasps104512092clasps
class75525482clas_s
classes94717942classes
clasts84817292clasts
clauses93813322clauses
claves115020062claves
closes85425592closes
coasts85719132coasts
coaxes154715632coaxes
copses104922472copses
corpses113913802corpses
corses84433462corses
coses76949492c_oses
craals84113302craals
crabs95421392cra_bs
cracks144817002cracks
cradles103114132cradles
crafts115312742crafts
crags85622572cra_gs
crake114823522crake_
crambes1339952crambes
cramps125615562cramps
crams96229152cra_ms
crane75331602crane_
craned96121652craned
cranks125015312cranks
crape96128442crape_
craped116120522craped
craps95328642cra_ps
crash109120012cras_h
crashed134214202crashed
crasher124616152crasher
crashers134013222crashers
crasser94114332crasser
crassest103411522crassest
crate76537402crate_
crated94827772crated
crater85026632crater
craters95021882craters
crave105626312crave_
craved125417772craved
craven114113932craven
cravens124010112cravens
craver114618462craver
cravers124416542cravers
crawls114712082crawls
craws105723122cra_ws
craze165221462craze_
crazed184714452crazed
crazies183413852crazies
crease85519572crease_
creased104315582creased
creaser94415722creaser
creasers103612812creasers
creates95225172creates
creeses93914622creeses
cremes104517992cremes
crepes105419342crepes
cress75022832cres_s
cresses94219812cresses
crests85218702crests
cries75438402cr_ies
crimes105521582crimes
cripes105120872cripes
crisis83716342crisis
crisps104411512crisps
crones84729242crones
crores86121162crores
cross75124502cros_s
crosse85216302crosse
crosses94220792crosses
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
cruises93514442cruises
cruse75726102cruse_
cruset84425092cruset
crusets93811042crusets
crushes124215132crushes
crusts84916542crusts
cruxes154911562cruxes
curares94916852curares
curates95323822curates
curses85328272curses
cusses84522772cusses
cycases1437532cycases
cyeses11510122cyeses
drakes114715862drakes
drapes95419652drapes
druses75517252druses
eases56041612_eases
ectases92911672ectases
erase54925492erase_
erased74816752erased
eraser64216332eraser
erasers74413942erasers
eroses65327052eroses
erses55826802er_ses
eyases94513682eyases
feases95422922feases
fraises104215692fraises
frames115119862frames
frass85321122fras_s
frasses104314512frasses
frises94124272frises
gases65633992_gases
graces94523492graces
grades84926312grades
grapes95123122grapes
grasps9489252grasps
grass66125202gras_s
grasses84117342grasses
grates75429882grates
graves104624002graves
grazes164519642grazes
greases84816712greases
gyrases11368312gyrases
irades74517392irades
irises64221172irises
krises105016082krises
kvases13467102kvases
lases54944762_lases
leases65428112leases
lyases95211872lyases
marses84827112marses
myases113711552myases
oases55330982_oases
orates64328612orates
parses85534702parses
pases75346502_pases
peases85229472peases
phases114618402phases
phrases12711462phrases
praises94121102praises
prase76128752prase_
prates84633162prates
praxes156215182praxes
prises84133172prises
proses84733472proses
races74943242_races
rages64539442_rages
raises64826542_raises
rajes125022782_rajes
rakes94440352_rakes
rales54947492_rales
rapes75740722_rapes
rares55247442_rares
rase46149982_rase_
rased65033932_rased
raser55633412_raser
rasers64526782_rasers
rashes95330152_rashes
rasps74316662_rasps
rates55352012_rates
raves85441972_raves
raxes124729392_raxes
razes145032702_razes
rises55244042_rises
roses56445772_roses
ruses56136582_ruses
scrapes116217662scrapes
stases64225562stases
sucrases10310252sucrases
teases65426272teases
traces85329932traces
trades75724492trades
trapes85024462trapes
trashes104119252trashes
trass56226472tras_s
trasses74819322trasses
traves94222742traves
ukases10358062ukases
upases84112902upases
urares64519092urares
urase54624682urase_
urates65027762urates
ureases74416722ureases
uruses63616502uruses
vases84626262_vases
wrasse9398772wrasse
wrasses103812592wrasses

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825512742.79629524.7
3Display Results2742740.0932946.2
 (SQL Overall)1786912742.99959583.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.