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

509 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
crusting11361279(None) 
cresting114017041cresting
crushing143010051crushing
rusting83821261_rusting
trusting93411651trusting
becrusting1544602becrusting
bruiting11259972bruiting
brushing14359962brushing
bruting102612992bru_ting
bursting1138702bursting
busting104221792_busting
casting104628342c_asting
causing103614412caus_ing
chuting132910732chu_ting
coasting113615502coasting
costing104323022c_osting
counting113115262counting
courting112514562courting
crafting143710172crafting
crashing143512632crashing
crating103725202cr_ating
creating113921952creating
crestings12298042crestings
crisping13319662crisping
crossing112612682crossing
crostini1038292crostini
crostino1038882crostino
crudding1335722crudding
cruising112610152cruising
crumbing15267812crumbing
crumping15319902crumping
crusading1344112crusading
crustier10259532crustier
crustily13328172crustily
curating11314292curating
cursing104217032curs_ing
cussing103814272c_ussing
cutting103817492c_utting
dusting93618992_dusting
encrusting13125292encrusting
eructing112110172eructing
erupting11218442erupting
frosting12311182frosting
fruiting12229062fruiting
grunting10269582grunting
gusting93917162_gusting
incrusting13126472incrusting
jousting16309352jousting
justing153615162_justing
lusting83619322_lusting
musting103221072_musting
ousting84021352_ousting
resting85031182_resting
rousting93913272rousting
rushing113817702_rushing
rustling9249982_rustling
rutting82718042_rutting
thrusting1335002thrusting
trussing9268652trussing
trysting12267052trysting
wresting123811832wresting
abusing1049113abus_ing
abutting1137003abutting
accosting1446733accosting
accusing1336783accus_ing
actuating1239223actuating
adjusting1843823adjusting
agisting1038243agisting
amusing1039383amus_ing
arising83619973aris_ing
arousing93811803arous_ing
arresting1038633arresting
basting104227203_basting
besting104923923_besting
blasting114013423blasting
blunting11319843blunting
blurting11258773blurting
blushing14339333blushing
boasting113512493boasting
boosting113311053boosting
bousing103718043bous_ing
brassing112612303brassing
breasting1239583breasting
brisking15329473brisking
brisling112410843brisling
bristling1246663bristling
bruising11279143bruising
bruxing17236823bru_xing
bunting103718833_bunting
bushing134018583_bushing
busing96420593_bus_ing
busking144116573_busking
bussing103614623_bussing
bustling112110063_bustling
busying134211993_busying
butting103519283_butting
canting104725903c_anting
caressing1238803caressing
carousing1237893carous_ing
carpeting1439483carpeting
carting104228283c_arting
cashing135022553c_ashing
casing94829103c_as_ing
casking144317353c_asking
castings113614053c_astings
castling11311233c_astling
catting103922643c_atting
caulking1536803caulking
caustic1139743causti_c
caustics1237483caustics
ceasing104118263ceas_ing
censing104215263cens_ing
cessing103814813c_essing
chanting143413533chanting
charting142614193charting
chasing133715893chas_ing
chatting142810143chatting
chaunting1555413chaunting
cheating144014523cheating
chorusing15246113chorus_ing
chorussing16193323chorussing
chousing14259423chous_ing
chucking20379503chucking
chuffing2055043chuffing
chugging1634913chugging
chumming18366203chumming
chumping18349063chumping
chunking18328053chunking
churning14237173churning
churring14298653churring
circuiting1545363circuiting
citing94220183c__iting
clashing143812193clashing
clasping133310263clasping
classing113211793classing
cleating113518133cleating
clefting14347583clefting
closeting1236183closeting
closing103114843clos_ing
clotting113110643clotting
clouting113011683clouting
clubbing15266513clubbing
clucking17429993clucking
clueing104110093clu_eing
cluing93913503clu__ing
clumping15319883clumping
clunking15329433clunking
clustering13116813clustering
coacting133412693coacting
coapting133511603coapting
coastings12357863coastings
coating103525303c_oating
cohosting1546323cohosting
combusting1745423combusting
compting153013603compting
coopting133411313coopting
corrupting1555573corrupting
corseting12312173corseting
coruscating1644673coruscating
coshing134316433c_oshing
cosseting1239543cosseting
cosying134513133c_osying
coting94629253c__oting
couching163213263couching
coughing15309213coughing
couping124317023cou_ping
coupling13310783coupling
coursing113112023coursing
cousin8517153cous_in_
cousins9516003cous_ins
coveting141912303coveting
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
cramming15339433cramming
cramping153411853cramping
craning103620303cr_aning
cranking154613073cranking
craping124018713cr_aping
crapping153911453crapping
craving134015733cr_aving
crawling143110513crawling
crazing193914583cr_azing
creaking153414113creaking
creaming133413143creaming
creasing113314443creasing
creatin93618133creatin_
creatine103417413creatine
creatins103617513creatins
crediting1338843crediting
creeling113513363creeling
creeping133310103creeping
creeshing1536243creeshing
cremating14312183cremating
creosoting1343793creosoting
creping122913653cr_eping
cretin82917913cr_etin_
cretins93216423cr_etins
crewing133212623cr_ewing
cribbing15276843cribbing
cricking173412653cricking
crimping15299783crimping
cringing123311383cringing
croaking153712153croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210883cropping
croqueting2243173croqueting
crossings12217163crossings
crouching1746383crouching
crowding15247933crowding
crowing133814763cr_owing
crowning143510033crowning
cruisings12214113cruisings
crumbling1655083crumbling
crumpling1645323crumpling
crunching17297003crunching
crushingly1963603crushingly
crusily12199093crus_ily
crust75827663crust___
crustal939023crust_al
crusted103712753crust_ed
crustiest112410043crustiest
crustiness1237263crustiness
crustose1045503crustose
crusts84916543crust__s
crusty114911343crust__y
crutching17216073crutching
crying123612283cr__ying
cubing114213943c_u_bing
cueing94913613c_u_eing
cuffing163210253c_uffing
cuing85420193c_u__ing
culling103921303c_ulling
culming123811183c_ulming
cunning104214623c_unning
cupping144312383c_upping
curbing123814023c_urbing
curding113515133c_urding
curdling12228893curdling
curetting1236573curetting
curing94824783c_u_ring
curling104320183c_urling
curring103616843c_urring
currying14196483currying
curtsying1543813curtsying
curveting1535353curveting
curving133912103c_urving
cutin75022773c_u_tin_
cutins83919983c_u_tins
cuttings11277613c_uttings
cuttling1138203c_uttling
cystine1239333c_ystine
daunting103310403daunting
dauting93814763dau_ting
degusting1236163degusting
doubting1237373doubting
dousing93315763dous_ing
drafting13339403drafting
dratting10389653dratting
dressing102810423dressing
drifting13338733drifting
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
ducting113713593_ducting
dueting93814393_dueting
dunting93418383_dunting
dusking133912053_dusking
dustings10419033_dustings
easting84924303_easting
egesting1039013egesting
eluting84115293elu_ting
entrusting11126183entrusting
equating18310113equating
erasing8317953eras_ing
erecting112415063erecting
existing1639073existing
exulting1637643exulting
fasting114522833_fasting
faulting12237733faulting
feasting122011323feasting
fisting113818123_fisting
flushing15288833flushing
fluting113815093flu_ting
foisting122910503foisting
foresting13311363foresting
freshing152611023freshing
fretting122711523fretting
frisking16268363frisking
fritting123510703fritting
fronting12310443fronting
frostings1335733frostings
frowsting1634683frowsting
frugging14317053frugging
fusing104415953_fus_ing
fussing113611683_fussing
gasting95022763_gasting
ghosting1336463ghosting
glutting10247643glutting
grafting13319623grafting
granting103514523granting
grasping12348833grasping
grassing103311973grassing
grating93923183gr_ating
greeting103112353greeting
grifting13299263grifting
gritting10309983gritting
grossing103111063grossing
grousing103410453grous_ing
grouting103410793grouting
grubbing14295403grubbing
grudging12255993grudging
grueling1078273grueling
gruffing1635273gruffing
grumping14266903grumping
gruntling1134263gruntling
guesting1058463guesting
gushing124014223_gushing
gutting93415923_gutting
hasting114725193_hasting
haunting123510053haunting
heisting123411043heisting
histing113720373_histing
hoisting123610903hoisting
hosting114318383_hosting
housing113316523hous_ing
hunting114317123_hunting
hurting113914033_hurting
hushing144514473_hushing
husking154312053_husking
hustings12378683_hustings
hustling12228793_hustling
hutting113016033_hutting
inrushing1365503inrushing
intrusting11128173intrusting
irising83614423iris_ing
irrupting1243543irrupting
jaunting16328633jaunting
jesting154317713_jesting
joisting16328503joisting
justling16207253_justling
jutting153313713_jutting
lasting84725243_lasting
listing84020593_listing
lousing83817733lous_ing
louting83719383lou_ting
lunting83817743_lunting
lushing114316113_lushing
lustring9269723_lustring
luting75221753_lu_ting
masting104325823_masting
misting103623383_misting
moulting112710313moulting
mounting112711813mounting
mousing103816273mous_ing
moussing1138143moussing
munting103718773_munting
mushing134217633_mushing
musing93919503_mus_ing
mussing104015543_mussing
mustang10267933_mustang
muting93921523_mu_ting
nesting84320443_nesting
nursing84012553nurs_ing
nursling997603nursling
nutting83316233_nutting
occulting1445103occulting
onrushing1364813onrushing
orating83520323or_ating
orbiting1138153orbiting
outing74128153_ou_ting
outsing83320463_outsing
pasting103826553_pasting
pausing103912813paus_ing
perusing11811063perus_ing
posting105622243_posting
pouting103519943pou_ting
prating103424453pr_ating
pressing112516443pressing
priesting1239483priesting
printing113216083printing
prising103321453pris_ing
prissing113011453prissing
pristine10313503pristine
prosing103319383pros_ing
pruning10311733pru_ning
punting103318443_punting
pursing103715553purs_ing
pursuing1146233pursuing
pushing133615453_pushing
putting103218573_putting
questing1838273questing
quoting17310043_quoting
rafting113815753_rafting
ranting84025413_ranting
rasing74330833_ras_ing
rasping104316253_rasping
rating74938703_r_ating
ratting83822363_ratting
recruiting1347903recruiting
reesting93118273reesting
renting84026853_renting
resiting93521123_resiting
restring91518783_restring
retting83425883_retting
reusing82516783reus_ing
rifting113515003_rifting
rioting82716393_rioting
rising74025883_ris_ing
risking123914243_risking
roasting93012693roasting
roosting93411453roosting
rooting83522433_rooting
rosing73925593_ros_ing
rotting82919683_rotting
rousing83920553rous_ing
routing83821093_routing
rubbing123412273_rubbing
rubying13297933_rubying
ruching133612933_ruching
rucking143216673_rucking
ruffing143210843_ruffing
rugging102512763_rugging
ruing67221053_ru__ing
ruining83514883_ruining
ruling73219553_ru_ling
running83514593_running
rushings12387843_rushings
rusine63916593_rus_ine
russeting1065323_russeting
rustic8712673_rusti_c
rustics9810733_rustics
rustier74416363_rustier
rustily103112993_rustily
rutin55421343_ru_tin_
rutins63818393_ru_tins
schussing1542953schussing
scouting112612753scou_ting
scripting1437473scripting
scrubbing1633933scrubbing
scrumming1654023scrumming
scrupling1435193scrupling
scrutiny1344773scru_tiny
shunting123610423shunting
shushing15317743shushing
shuting113212043shu_ting
shutting12309683shutting
slushing12299643slushing
smushing14287453smushing
smutting11278063smutting
sousing83517823sous_ing
spurting113111633spurting
sting65330243___sting
strunting1037873strunting
strutting1037003strutting
stunting92811503stunting
suiting83419003_suiting
sussing84013703_sussing
tasting84624213_tasting
taunting93510933taunting
tauting83316383tau_ting
testing86021053_testing
toasting93410573toasting
tousing82916993tous_ing
tousling938793tousling
touting84118453tou_ting
trashing122613223trashing
treating92519613treating
trotting92510913trotting
truanting1035603truanting
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trumping13308733trumping
trussings10224033trussings
trusteeing1142893trusteeing
trustier8268683trustier
trusties82712853trusties
trustily11257103trustily
trustingly1444373trustingly
tufting11289873_tufting
tushing114214013_tushing
tusking124212063_tusking
tutting83515913_tutting
twisting12427813twisting
unresting10311133unresting
untrusting1186003untrusting
uprushing1544043uprushing
using66317963__us_ing
vaulting12227223vaulting
vaunting12338753vaunting
vesting114618683_vesting
waisting123615213waisting
wasting114422843_wasting
westing115020273_westing
whisting15329543whisting
wisting113519743_wisting
worsting1267683worsting
wrastling1335523wrastling
wrestling1336063wrestling
writing113713893wr_iting
yeasting12188923yeasting
zesting174515333_zesting

Search took 10 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.326548131.9
2DLD Change Limit1461625098.81316584.8
3Display Results5095090.2032507.4
 (SQL Overall)1786915099.34219127.7
 
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.