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

136 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
carracks163771(None) 
arracks1387731_arracks
barracks1636881barracks
caracks152211561ca_racks
carjacks2345571carjacks
carrack1548751carrack_
arrack121110252_arrack_
barrack1538252barrack_
calpacks18266522calpacks
caprocks1835942caprocks
carack142113172ca_rack_
carjack2246152carjack_
carrybacks2352112carrybacks
coatracks1745402coatracks
cracks144817002c__racks
currachs1544542currachs
hatracks1737532hatracks
hayracks2045312hayracks
amtracks1696633amtracks
araks94820883_a_ra_ks
arras55626133_arra__s
arrases71214543_arrases
arrays95311683_arra_ys
attacks13126943_attacks
barracked1844753barracked
barracker1744653barracker
barrackers1843763barrackers
barrages11711083barrages
barrancas1345093barrancas
barrancos1344203barrancos
callbacks1945023callbacks
calpack17338333calpack_
calpacs133110343calpac_s
caprices1439893caprices
caprock1736813caprock_
caracal11312513ca_racal
caracals12310753ca_racals
caracol11310423ca_racol
caracols12310413ca_racols
caracul1138823ca_racul
caraculs1238033ca_raculs
carafes125015703ca_rafes
carapaces1546053carapaces
carates95630613ca_rates
carats85929023ca_ra_ts
carbarns1238563carbarns
carcases12313093carcases
carcass11310513carca_ss
cardiacs1376913cardiac_s
carfares13310323carfares
carices114220953ca_rices
cariocas1239663cariocas
carjacked2543353carjacked
carjacker2443833carjacker
carjackers2553413carjackers
carks115534213ca_r__ks
carnages11312213carnages
caroach1488863caroac_h
caroaches1637793caroaches
carpals113414623carpa_ls
carrells10359273carrells
carrels95117303carr_els
carriages1238333carriages
carriers103614203carriers
carries94328013carr_ies
carrions10312453carrions
carroch1437093carroc_h
carroches1665893carroches
carroms11512403carr_oms
carrots9714623carr_ots
carrs75730853carr___s
carryalls1443523carryalls
carryback2252393carryback_
carryons1337103carryons
carsick1536343carsick_
cartages11313313cartages
cassocks1645033cassocks
cataracts1345583cataracts
catfaces1536963catfaces
catwalks1744793catwalks
charlocks2044073charlocks
clacks144516343c__lacks
clawbacks2243623clawbacks
coalsacks1743513coalsacks
coatrack1645853coatrack_
corrades111211263corrades
corrals93713853corra_ls
corrects1259573corrects
corsacs1139013corsac_s
cossacks1645223cossacks
crack134120533c__rack_
cracky175010223c__racky
cranks125015313c__ranks
creaks124315963c_rea_ks
cricks144316053c__ricks
croaks125812983c_roa_ks
crocks145118423c__rocks
crucks144412583c__rucks
currach1446453currac_h
curraghs1442883curraghs
currans9310613curra_ns
currants1037933currants
cutbacks1845813cutbacks
derricks1544433derricks
earlocks1435693earlocks
earmarks1444793earmarks
fatbacks1946003fatbacks
hardbacks2145373hardbacks
hardhacks2243703hardhacks
hardpacks2143623hardpacks
hardtacks1943803hardtacks
hatrack1638213hatrack_
hayrack1945543hayrack_
hayricks2043763hayricks
jarrahs1735453jarra_hs
lavrocks1743663lavrocks
maracas11313773ma_racas
marrams11310123marra_ms
marranos1038423marranos
narrates8312763narrates
oarlocks1445103oarlocks
parrals94414573parra_ls
paybacks2145493paybacks
racks115028853___racks
ransacks1445773ransacks
reracks132310533_reracks
retracks14149103retracks
scatbacks1974713scatbacks
tamaracks1743753tamaracks
tarmacs1138323tarmac_s
terraces102712253terraces
tracks124818843__tracks
untracks1437523untracks
warlocks1735363warlocks
warrants1168503warrants
wracks154711113__wracks

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.420425454.8
2DLD Change Limit1461621366.97020970.2
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.43624030.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.