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 “cassocks” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
cassocks164503(None) 
cassock1545951cassock_
hassocks1744691hassocks
caprocks1835942caprocks
cossacks1645222cossacks
hassock1645442hassock_
tussocks1443332tussocks
assoils776663_assoils
assorts73310153_assorts
bannocks1644353bannocks
bassoons1036553bassoons
bassos85313703basso__s
bawcocks21113443bawcocks
caissons1036283caisso_ns
calpacks18266523calpacks
cansos84915383canso__s
caprock1736813caprock_
caracks152211563ca_racks
cariocas1239663cariocas
carjacks2345573carjacks
carracks1637713carracks
carsick1536343carsick_
casebooks1743793casebooks
caseoses1039293caseoses
caseous9312513caseo_us
caseworks1846413caseworks
cashbooks2043223cashbooks
cashoos12310793casho_os
casks115720063ca_s__ks
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassenas10317483cassenas
cassenes103611293cassenes
cassias93514343cass_ias
cassinas103610633cassinas
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cass__is
cassises103811743cassises
castoffs1644043castoffs
castors94919443casto_rs
charlocks2044073charlocks
chocks174815313c__hocks
cissoids1145363cissoids
classics12418873classic_s
classons1037703classo_ns
classworks1943313classworks
clocks144916233c__locks
coalsacks1743513coalsacks
cocks135227163c___ocks
cossack1545823cossack_
crocks145118423c__rocks
cussos84210003cusso__s
daglocks1643993daglocks
earlocks1435693earlocks
fatstocks1843453fatstocks
fossicks17134163fossicks
gasworks1645943gasworks
haddocks1984903haddocks
hammocks2164343hammocks
haycocks2244113haycocks
lassoers8338513lassoers
lassoes74613853lasso_es
lassos64913813lasso__s
lavrocks1743663lavrocks
mammocks1763893mammocks
mattocks1644983mattocks
oarlocks1445103oarlocks
paddocks1894323paddocks
padlocks1755473padlocks
passbooks1743163passbooks
ransacks1445773ransacks
restocks1437503restocks
shocks154414583__shocks
smocks145710013__smocks
socks114926083___socks
stocks124715633__stocks
tussock1343833tussock_
tussocky1741493tussocky
tussucks1442433tussucks
waesucks1742553waesucks
warlocks1735363warlocks
yapocks18354723ya_pocks

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.1561145455.1
2DLD Change Limit146162847.64019131.2
3Display Results84840.0332545.5
 (SQL Overall)178691847.82922824.2
 
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.