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

243 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
caroused114925(None) 
aroused84914341_aroused
carouse9614421carouse_
carousel1057311carousel
carouser1068851carouser
carouses10614501carouses
arouse65019982_arouse_
arouser74514422_arouser
arouses74921292_arouses
calloused1244402calloused
callused1135852callused
campused1535252campused
caressed1139162caressed
caroled103717692caro_led
carolled1138832carolled
caroluses1157612caroluses
caromed123713622caro_med
carousal1056282carousal
carousels1165342carousels
carousers1156742carousers
carrousel1174372carrousel
caucused1344092caucused
caused95117042ca__used
chorused1446132chorused
choused135012462c_housed
crossed105313892c_rossed
crouse84619362c_rouse_
groused94712832_groused
rearoused1047092rearoused
roused75426442__roused
unaroused1046522unaroused
uproused1135832uproused
abused95614273_a_bused
accused12368423_accused
amused94412513_a_mused
arboured1156253_arboured
arcuses94814693_arcuses
argued84311173_argu_ed
arguses84711743_arguses
armoured1165223_armoured
arose55832083_aro_se_
around72712413_arou_nd
arousal748633_arousal
arousers84810983_arousers
arrased8149863_arrased
berouged1235333berouged
bloused104310643_bloused
boused95322883__boused
browsed134511233_browsed
caboched1844043caboched
caboose1138273caboose_
cabooses1237863cabooses
caboshed1634393caboshed
cactuses1237933cactuses
caddised13315893caddised
cajoled17428283cajo_led
callouses1147683callouses
calluses1039323calluses
calqued19306523calqu_ed
campuses1437773campuses
canoed94618963cano__ed
canonised1256713canonised
canopied1336343canopied
canvased14246223canvased
capsuled1334533capsuled
captured1336573captured
carboyed1637183carboyed
carburet12411113carburet
carburised1543983carburised
carcase11312743carcase_
carcases12313093carcases
carded105424903car__ded
cared86050093car___ed
careened1139193careened
careered1139493careered
caresser1038813caresser
caresses10314063caresses
carhopped1972763carhopped
caried94528693car__ied
carious93320283carious__
carked134024823car__ked
carobs104818103carobs__
caroche1469243caroche_
caroches15710693caroches
caroler93816753caro_ler
caroller1039203caroller
carols85124983carols__
carolus94612603carolus__
caroms105619573caroms__
carotid102014833caro_tid
carousals1165343carousals
carousing1237893carousing
carped115923763car__ped
carpeted1338953carpeted
carpooled1445073carpooled
carpus105514303carpus__
carried103717153car_ried
carromed1338563carromed
carrousels1253263carrousels
carse74934333car__se_
carses85233653car__ses
carted98631443car__ted
cartoned111312833cartoned
cartooned1246313cartooned
carved124320853car__ved
caryopses1645043caryopses
cased86032413ca___sed
casqued19235633casqu_ed
cathouse1338863cathouse_
cathouses1439433cathouses
caucuses1236783caucuses
caucussed1441913caucussed
cause75225353ca__use_
causer84117783ca__user
causes88026473ca__uses
causey113513273ca__usey
cavorted1435693cavorted
cayuse11207763ca_yuse_
cayuses12188403ca_yuses
censused11184973censused
cereuses1049243cereuses
cerous85821203cerous__
ceruse83914523cer_use_
ceruses93716233cer_uses
chamoised17335323chamoised
choruses1339983choruses
chorussed1543213chorussed
chouse116017563c_house_
chouser125212943c_houser
chouses125117813c_houses
chowsed16478613c_howsed
chromed153510923chro_med
circuses1238253circuses
clamoured1444083clamoured
closed95317963c_lo_sed
clouded11348833c_louded
cloured103111543c_loured
clouted104212163c_louted
coloured1148313coloured
confused1437033confused
contused1138443contused
cornuses10310033cornuses
cornuted1137473cornuted
corpuses12310063corpuses
couped115019313c__ouped
coursed104113603c__oursed
creased104315583c_reased
croaked143710533c_roaked
crocked164014433c_rocked
crocuses1239023c_rocuses
crooked143910943c_rooked
crooned103813343c_rooned
cropped143812063c_ropped
crosse85216303c_rosse_
crosser95015463c_rosser
crosses94220793c_rosses
crouched16359143c_rouched
croupe105114433c_roupe_
croupes114613103c_roupes
crousely1346563c_rousely
croute84617273c_route_
croutes94815653c_routes
crowded14418793c_rowded
crowed124717303c_ro_wed
crowned133912433c_rowned
cruised103710213c_ruised
cruse75726103c_r_use_
cruses88127713c_r_uses
cruset84425093c_r_uset
crushed134111963c_r_ushed
crusted103712753c_r_usted
curiouser1153433curiouser
cursed94321253cur__sed
cyanosed1444613cyano_sed
deloused1036973deloused
doused84821163__doused
drouked1335543_drouked
drowsed12448743_drowsed
espoused1134853espoused
favoured1533963favoured
gallused1034193gallused
garoted9710133garo_ted
garotted1066193garotted
grossed93812253_grossed
grouped11419193_grouped
grouse74315023_grouse_
grouser84513693_grouser
grouses84616543_grouses
grouted94111503_grouted
harassed1237113harassed
harboured1544313harboured
housed105624103__housed
jalousied1742033jalousied
karosses1236493karosses
laboured1156333laboured
larruped1142863larruped
loused74822913__loused
marauded1244333marauded
marooned1138563marooned
moused94423303__moused
parodied1238333parodied
paroled104217633paro_led
parous84024163parous__
parsed96323893par__sed
paused95114963pa__used
perfused1445833perfused
perused103112193per_used
prosed94921093_pro_sed
ragouted1034423ragouted
rearouse839363rearouse_
rearouses9310203rearouses
rehoused1239613rehoused
rerouted9311143rerouted
reused75419563__reused
roosed75621593__roosed
rosed65930343__ro_sed
rouged86717323__rouged
rouped95717353__rouped
rouse56634703__rouse_
rouser65224083__rouser
rouses65436283__rouses
rousted84013323__rousted
routed75624333__routed
saroses73619333saro_ses
savoured1234793savoured
scrouged1235383scrouged
shrouded1333603shrouded
soused74822983__soused
spoused10349653_spoused
sprouted1136393sprouted
taboured1156273taboured
toused74122013__toused
trouped103910983_trouped
trouser73812473_trouser
unhoused1238153unhoused
uprouse937223uprouse_
uprouses1037553uprouses
vamoosed1443923vamoosed
vamosed1335923vamo_sed
vapoured1434353vapoured
varoomed1445293varoomed
varuses10310623var_uses
warehoused1743743warehoused

Search took 9 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.453394461.4
2DLD Change Limit1461622437.44019645.4
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.98622375.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.