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

87 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
jockeyed256341(None) 
cockeyed2096121cockeyed
cockered17710212cockered
cockeye1867222cockeye_
cockeyes1967032cockeyes
docketed16156582docketed
jacketed22146532jacketed
jockey22408032jockey__
jockeys23365952jockey_s
lackeyed18104512lackeyed
monkeyed1844152monkeyed
pocketed17147142pocketed
rocketed15157792rocketed
socketed15177342socketed
sockeye1666412sockeye_
sockeyes1765762sockeyes
bickered17108003bickered
bogeyed1435673bo_geyed
boogeyed1543723boogeyed
bucketed1736763bucketed
buckeye1835683buckeye_
buckeyes1945263buckeyes
cockaded1836393cockaded
cocked155022563cock__ed
cockerel16107113cockerel
cockeyedly2551553cockeyedly
cockled163710823cock_led
conveyed17247923conveyed
cooeyed1346893co_oeyed
crocketed1845123crocketed
dackered16116893dackered
dickered16117533dickered
docked145018333dock__ed
foureyed1543663foureyed
hackneyed2242243hackneyed
hawkeyed2242403hawkeyed
hocked165521303hock__ed
hockey184813153hockey__
hockeys19509273hockey_s
honeyed1437773ho_neyed
hoseyed1436953ho_seyed
jacked204817523jack__ed
jerseyed1942743jerseyed
jockette2165033jockette
jockettes2254383jockettes
jockeying2663293jockeying
jockeyish2841843jockeyish
joked175217913jo_k__ed
jokey195014693jo_key__
jonesed1536263jo_nesed
jouked18568153jouk__ed
journeyed2041983journeyed
joyed164811833jo___yed
junketed2033523junketed
keyed1369393___keyed
lackered15108683lackered
locked134921663lock__ed
mocked154716613mock__ed
moneyed1337493mo_neyed
moseyed1336133mo_seyed
nickeled15115513nickeled
nickered15117023nickered
nocked134617383nock__ed
obeyed1235823_o_beyed
ochered132610283_ochered
okayed1434253_o_kayed
outjockeyed285673outjockeyed
packeted17148283packeted
picketed17167383picketed
pocked154818983pock__ed
pocketer16157373pocketer
popeyed1535713po_peyed
puckered1736103puckered
racketed15169123racketed
rekeyed1536163_rekeyed
rocked135022323rock__ed
rocketer14158333rocketer
rockweed1843313rockweed
sickened1546783sickened
socked134721503sock__ed
suckered1537833suckered
ticketed15146643ticketed
tochered1437913tochered
tokened1236393to_kened
tuckered1535963tuckered
volleyed1543533volleyed
yocked164114423yock__ed

Search took 7 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.403443402.0
2DLD Change Limit146162876.22023498.7
3Display Results87870.0461891.3
 (SQL Overall)178691876.66926794.3
 
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.