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

203 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
carouser106885(None) 
arouser74514421_arouser
carouse9614421carouse_
caroused1149251caroused
carousel1057311carousel
carousers1156741carousers
carouses10614501carouses
arouse65019982_arouse_
aroused84914342_aroused
arousers84810982_arousers
arouses74921292_arouses
caresser1038812caresser
caroler93816752caro_ler
caroller1039202caroller
caroluses1157612caroluses
carousal1056282carousal
carousels1165342carousels
carrousel1174372carrousel
causer84117782ca__user
chouser125212942c_houser
crosser95015462c_rosser
crouse84619362c_rouse_
curiouser1153432curiouser
grouser84513692_grouser
rouser65224082__rouser
trouser73812472_trouser
abuser85413683_a_buser
accouter1245363accouter
accuser11347933_accuser
amuser84712623_a_muser
arcuses94814693_arcuses
arguer74510543_argu_er
arguses84711743_arguses
armourer1054883_armourer
arose55832083_aro_se_
arousal748633_arousal
browser124911143_browser
caboose1138273caboose_
cabooses1237863cabooses
cactuses1237933cactuses
cajoler16398393cajo_ler
calloused1244403calloused
callouses1147683callouses
callused1135853callused
calluses1039323calluses
caloyer1238143calo_yer
campused1535253campused
campuses1437773campuses
canoer85121073cano__er
canvaser13276563canvaser
caponier1237883caponier
capturer1246093capturer
carburet12411113carburet
carcase11312743carcase_
carcases12313093carcases
carder94524183car__der
careener1039333careener
career85822243car__eer
careerer1038583careerer
carer74942333car___er
caressed1139163caressed
caressers1137443caressers
caresses10314063caresses
carious93320283carious__
carmaker1637313carmaker
carobs104818103carobs__
caroche1469243caroche_
caroches15710693caroches
caroled103717693caro_led
carolers103314173caro_lers
carolled1138833carolled
carollers1137703carollers
carols85124983carols__
carolus94612603carolus__
caromed123713623caro_med
caroms105619573caroms__
carousals1165333carousals
carousing1237893carousing
carper104923633car__per
carpooler1345313carpooler
carpus105514303carpus__
carrier93619583car_rier
carrotier1146623carrotier
carrousels1253263carrousels
carse74934333car__se_
carses85233653car__ses
carter84932273car__ter
cartopper1543743cartopper
carver114420153car__ver
caryopses1645043caryopses
cathouse1338863cathouse_
cathouses1439433cathouses
caucused1344093caucused
caucuses1236783caucuses
cause75225353ca__use_
caused95117043ca__used
causers94014793ca__users
causes88026473ca__uses
causey113513273ca__usey
cavorter1335783cavorter
cayuse11207763ca_yuse_
cayuses12188403ca_yuses
cereuses1049243cereuses
cerous85821203cerous__
ceruse83914523cer_use_
ceruses93716233cer_uses
chooser124412973c_hooser
chorused1446133chorused
choruses1339983choruses
chouse116017563c_house_
choused135012463c_housed
chousers134610203c_housers
chouses125117813c_houses
chromier1538033chromier
circuses1238253circuses
closer84918203c_lo_ser
clouter93511693c_louter
coarser93211203coar__ser
colourer1037563colourer
cornuses10310033cornuses
coroner94218203coro_ner
corpuses12310063corpuses
coruler9311713cor_uler
courser94114803c__ourser
couter84930223c__outer
crasser94114343c_rasser
creaser94415743c_reaser
croaker133010683c_roaker
crocuses1239023c_rocuses
crofter12299573c_rofter
crooker134111093c_rooker
crooner93714043c_rooner
cropper133312963c_ropper
crosier94116573c_rosier
crosse85216303c_rosse_
crossed105313893c_rossed
crossers103912703c_rossers
crosses94220793c_rosses
croupe105114433c_roupe_
croupes114613103c_roupes
croupier1246883c_roupier
crousely1346563c_rousely
croute84617273c_route_
croutes94815653c_routes
crowder13389863c_rowder
crower114117563c_ro_wer
crowner124012603c_rowner
crozer175112843c_ro_zer
crozier18369933c_rozier
cruder95612383c_r_uder
cruiser93410433c_ruiser
cruse75726103c_r_use_
cruses88127713c_r_uses
cruset84425093c_r_uset
crusher124412323c_r_usher
curser84721473cur__ser
delouser936363delouser
douser75621633__douser
espouser1044383espouser
favourer1443823favourer
garotter965943garotter
grosser84313143_grosser
grouper104210093_grouper
grouse74315023_grouse_
groused94712833_groused
grousers93810733_grousers
grouses84616543_grouses
grouter84412523_grouter
harasser1137043harasser
houser95322283__houser
karosses1236493karosses
labourer1045753labourer
larruper1042743larruper
marauder1144553marauder
mouser85822443__mouser
parous84024163parous__
parser84822373par__ser
pauser84415963pa__user
peruser93511373per_user
proser84223463_pro_ser
prouder10310383_prouder
rearouse839363rearouse_
rearoused1047093rearoused
rearouses9310203rearouses
rooser63921883__rooser
rouse56634703__rouse_
roused75426443__roused
rousers75220143__rousers
rouses65436283__rouses
rouster73517083__rouster
router65025843__router
saroses73619333saro_ses
savourer1134473savourer
tabourer1035743tabourer
trouper93811433_trouper
trousers83910633_trousers
unaroused1046523unaroused
uprouse937223uprouse_
uproused1135833uproused
uprouses1037553uprouses
vapourer1344263vapourer
varuses10310623var_uses
warehouser1643973warehouser

Search took 8 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.406440125.6
2DLD Change Limit1461622037.07620656.0
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.56223630.1
 
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.