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

57 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
worktable184472(None) 
workable1737091work_able
worktables1942611worktables
portable12313202por_table
sortable10312482sor_table
workably2044742work_ably
writable1338752w_ritable
boatable121610263bo_atable
bookable16127003book_able
bootable12179223bo_otable
cartable121314093car_table
cogitable1446943cogitable
constable13311003constable
cookable16147973cook_able
countable1348853countable
covetable1648163covetable
doubtable1445163doubtable
folktale1542873folkta_le
forceable1646213forceable
fordable1439593for_dable
forgeable1545403forgeable
formable1539503for_mable
heritable1439453heritable
irritable1148053irritable
locatable1345573locatable
lockable1636953lock_able
marketable1843223marketable
mockable1846643mock_able
mountable1346303mountable
notable92114903no__table
pocketable2043593pocketable
pointable1337343pointable
pokable15209503po_k_able
portables1337873por_tables
portably1539313por_tably
potable112115363po__table
ratable91717553__ratable
retable91820403__retable
rockable1638013rock_able
rotatable1146653rotatable
scrutable1346043scrutable
sorbable1239303sor_bable
sortably1338803sor_tably
torchable1645533torchable
totable92313363to__table
turntable1144983turntable
unworkable1944473unwork_able
veritable1448743veritable
votable122111373vo__table
walkable1736063walk_able
wastable131410453w_astable
wettable13148043w_ettable
wirable121610963wir__able
workfare1843123workfa_re
workmanly2151993workmanly
workmate1744673workma_te
writeable1444613w_riteable

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.1561145455.1
2DLD Change Limit148641577.15620771.5
3Display Results57570.0301900.0
 (SQL Overall)178691577.34224338.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.