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

133 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
carousel105731(None) 
carousal1056281carousal
carouse9614421carouse_
caroused1149251caroused
carousels1165341carousels
carouser1068841carouser
carouses10614501carouses
carrousel1174371carrousel
arousal748632_arousal
arouse65019982_arouse_
aroused84914342_aroused
arouser74514422_arouser
arouses74921292_arouses
caroluses1157612caroluses
carousals1165332carousals
carousers1156732carousers
carrousels1253262carrousels
crouse84619362c_rouse_
crousely1346562c_rousely
arcuses94814693_arcuses
arguses84711743_arguses
arose55832083_aro_se_
arousals866273_arousals
arousers84810983_arousers
caboose1138273caboose_
cabooses1237863cabooses
cactuses1237933cactuses
calloused1244403calloused
callouses1147683callouses
callused1135853callused
calluses1039323calluses
calomel1138073calo_mel
campused1535253campused
campuses1437773campuses
caramel11310253car_amel
caravel1238203car_avel
carburet12411113carburet
carcase11312733carcase_
carcases12313083carcases
carcel105018673car__cel
caressed1139163caressed
caresser1038803caresser
caresses10314063caresses
carful11610973carfu__l
carious93320283carious__
carobs104818103carobs__
caroche1469243caroche_
caroches15710693caroches
carol75128613caro___l
caroled103717693caro_led
caroler93816753caro_ler
carolled1138833carolled
caroller1039203caroller
carols85124983carols__
carolus94612603carolus__
caromed123713623caro_med
caroms105619573caroms__
carousing1237893carousing
carpel105418473car__pel
carpus105514303carpus__
carrel84718633car__rel
carse74934333car__se_
carses85233653car__ses
cartel85022533car__tel
carvel114817573car__vel
caryopses1645043caryopses
cathouse1338863cathouse_
cathouses1439433cathouses
caucused1344093caucused
caucuses1236783caucuses
causal81413203ca__usal
cause75225353ca__use_
caused95117043ca__used
causer84117783ca__user
causes88026473ca__uses
causey113513273ca__usey
cayuse11207763ca_yuse_
cayuses12188403ca_yuses
cereuses1049243cereuses
cerous85821203cerous__
ceruse83914523cer_use_
ceruses93716233cer_uses
chorused1446133chorused
choruses1339983choruses
chouse116017563c_house_
choused135012463c_housed
chouser125212943c_houser
chouses125117813c_houses
circuses1238253circuses
cocounsel1342513cocounsel
cornuses10310033cornuses
coronel94515223coro_nel
corpuses12310063corpuses
counsel948543c__ounsel
crocuses1239023c_rocuses
crosse85216303c_rosse_
crossed105313893c_rossed
crosser95015463c_rosser
crosses94220793c_rosses
croupe105114433c_roupe_
croupes114613103c_roupes
croute84617273c_route_
croutes94815653c_routes
cruel74815903c_r_u_el
cruse75726103c_r_use_
cruses88127713c_r_uses
cruset84425093c_r_uset
curiouser1153433curiouser
damosel10126693damo_sel
grouse74315023_grouse_
groused94712833_groused
grouser84513693_grouser
grouses84616543_grouses
housel95217043__housel
karosses1236493karosses
ousel55222403___ousel
parous84024163parous__
rearousal943493rearousal
rearouse839363rearouse_
rearoused1047093rearoused
rearouses9310203rearouses
rouse56634703__rouse_
roused75426443__roused
rouser65224083__rouser
rouses65436283__rouses
saroses73619333saro_ses
streusel843933streusel
trouser73812473_trouser
unaroused1046523unaroused
uprouse937223uprouse_
uproused1135833uproused
uprouses1037553uprouses
varuses10310623var_uses

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.486367677.0
2DLD Change Limit1461621337.59319249.6
3Display Results1331330.0462891.3
 (SQL Overall)1786911338.12521992.7
 
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.