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

116 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
carroming143768(None) 
caroming133312961ca_roming
arrowing1237942_arrowing
caroling113317002ca_roling
carrotin102210892carrotin_
carrotins11239962carrotins
carrying14148372carr_ying
cartoning12311112cartoning
chroming163410722c_hroming
corroding1337942corroding
farrowing1645872farrowing
garroting1136952garroting
harrowing1646432harrowing
marrowing1546662marrowing
narrowing1345602narrowing
parroting1239152parroting
varooming1545082varooming
aproning11311793_aproning
arming94719803_a_r_ming
armoring1149123_armoring
arraying1238753_arraying
arriving1237363_arriving
barraging1337383barraging
barreling1238043barreling
barring104021593barr__ing
borrowing1544563borrowing
brooming132911143_brooming
burrowing1544473burrowing
cajoling18318423ca_joling
calming123915973ca__lming
cameoing1379063cameo_ing
cannoning1237323cannoning
canoeing11310213ca_noeing
cantoning12310883cantoning
canyoning1536873canyoning
caprioling1544523caprioling
caracoling1545633caracoling
carbamino1545473carbamino
carding113922433ca_r_ding
careening12310013careening
careering12311203careering
caressing1238803caressing
carhopping2042993carhopping
caring95137993ca_r__ing
carking144322853ca_r_king
carling103727063ca_r_ling
carmine112918483ca_r_mine
carolling1259413carolling
carotin92216733ca_rotin_
carotins102315583ca_rotins
carousing1237893carousing
carpeting1439483carpeting
carping123521083ca_r_ping
carpooling1545023carpooling
carrom10513403carrom___
carromed1338563carrom_ed
carroms11512403carrom__s
carrotier1146623carrotier
carting104228283ca_r_ting
cartooning1345883cartooning
carving133916773ca_r_ving
caryotin13268353caryotin_
caryotins14248043caryotins
cavorting1536063cavorting
charioting1645723charioting
charming163012033char_ming
charring142913163charr__ing
chirming16318643chir_ming
chromings17286093c_hromings
clarioning1345183clarioning
coming114225453c___oming
cordoning1338063cordoning
cornrowing1643613cornrowing
corrading1338203corrading
cramming15339433c_ramming
crayoning1535243crayoning
creaming133413143c_reaming
crooking153611343c_rooking
crooning113112113c_rooning
crowing133814763c__rowing
curring103616843curr__ing
currying14196493curr_ying
earring83519013earr__ing
farming133515083fa_r_ming
fathoming1844693fathoming
furrowing1644063furrowing
garoting10510703ga_roting
garring93116713garr__ing
garrotting1254193garrotting
grooming12309513_grooming
harboring1538263harboring
harming133717933ha_r_ming
harrying15157643harr_ying
jargoning1845983jargoning
jarring153613193jarr__ing
larruping1243243larruping
marooning1238593marooning
marring103319553marr__ing
marrying14157223marr_ying
mirroring1246193mirroring
narrating10310353narrating
pardoning1338763pardoning
paroling113316213pa_roling
parring103222063parr__ing
parrying14168133parr_ying
pogroming1544733pogroming
ransoming1256513ransoming
rooming104117043__rooming
scarring112511513scarr__ing
sorrowing1344873sorrowing
tarring83318303tarr__ing
tarrying12146723tarr_ying
vrooming14287353_vrooming
wardrobing1742143wardrobing
warming133515083wa_r_ming
warring113717973warr__ing

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411167.34020250.8
3Display Results1161160.0502320.0
 (SQL Overall)1786911167.55023667.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.