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

107 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
sockeyes176576(None) 
cockeyes1967031cockeyes
sockeye1666411sockeye_
buckeyes1945262buckeyes
cockeye1867222cockeye_
cockeyed2096122cockeyed
hockeys19509272hockey_s
jockeyed2563412jockeyed
jockeys23365952jockey_s
sickees134514212sicke_es
socketed15177342socketed
sockets134012982socke_ts
ackees124914573_acke_es
buckeye1835683buckeye_
cockades1738433cockades
cockered17710213cockered
cockerel16107113cockerel
cockerels1784673cockerels
cockers153618333cocke_rs
cockles153414643cock_les
cockneys1934493cockney_s
cookeys16478503cookey_s
dickeys17479303dickey_s
dockages1635983dockages
dockers143715003docke_rs
docketed16156583docketed
dockets144412243docke_ts
donkeys15426663donkey_s
goldeyes1344483goldeyes
hackees165014103hacke_es
hickeys19508223hickey_s
hockers163915913hocke_rs
hockey184813153hockey__
honkeys17439513honkey_s
hookeys17448953hookey_s
jockettes2254383jockettes
jockey22408033jockey__
jockeyish2841843jockeyish
lackeyed18104513lackeyed
lackeys16458263lackey_s
lockages1536723lockages
lockers133516923locke_rs
lockets134612203locke_ts
mickeys18447943mickey_s
mockeries17128253mockeries
mockers153812943mocke_rs
monkeyed1844153monkeyed
monkeys16407423monkey_s
mooneyes1396113mooneyes
ockers123813903_ocke_rs
oxeyes1635893_o_xeyes
pinkeyes17335973pinkeyes
pocketed17147143pocketed
pocketer16157373pocketer
pocketers17196493pocketers
pockets154612253pocke_ts
pokeys15529513po_key_s
rickeys16548983rickey_s
rockabyes2042493rockabyes
rockeries15128973rockeries
rockers133916553rocke_rs
rocketed15157793rocketed
rocketer14158333rocketer
rocketers15186883rocketers
rockets134615363rocke_ts
sackers133820223sacke_rs
scenes84520353s_c_enes
schemes1489663s_chemes
scoleces1237073scoleces
screes85023963s_cre_es
secedes103711983sec_edes
secretes10410473secretes
shockers17319463shocke_rs
shuteyes1443473shuteyes
sickee124622223sicke_e_
sickened1546783sickened
sickener1436603sickener
sickeners1535733sickeners
sickens134411483sicke_ns
sickies133717503sick_ies
sickles133417543sick_les
sicklies14710013sicklies
skees95023123s__ke_es
skenes104616633s__kenes
soakages1336143soakages
soakers114114953soake_rs
socages101012053soc_ages
soccages1336383soccages
soccers1138393socce_rs
societies1148803societies
socked134721503sock__ed
socket123923523sock__et
sockless14267793sockless
sockmen1535453sock_men
socks114926083sock___s
socles8418453soc__les
soirees72411643soire_es
sokemen1337053so_kemen
sokes95031423so_k__es
solfeges1244083solfeges
stockades1644433stockades
stockages1644923stockages
stockers143411073stocke_rs
suckered1537833suckered
suckers133717623sucke_rs
suckles134516743suck_les
sycees11409653syc_e_es

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.1701051123.5
2DLD Change Limit1461621078.14017956.0
3Display Results1071070.0502140.0
 (SQL Overall)1786911078.36021374.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.