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

49 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
screwable164484(None) 
chewable1835442_chewable
screenable1443702screenable
screwball1662512screwball
scrutable1346042scrutable
sewable121911172s__ewable
stewable1337132s_tewable
agreeable1244653agreeable
ascribable1643483ascribable
creatable1339563_creatable
credible1346023_credible
crevalle1346163_crevalle
drawable1467113_drawable
fireable131710223fire_able
growable1435623_growable
hewable15177823__hewable
hireable13139083hire_able
renewable1447443renewable
retable91820403__retable
rowable121510303__rowable
saleable10312023sale_able
saveable1339003save_able
scalable121710233sc_alable
scannable1345643scannable
scoopable1544863scoopable
scrabble14196993scr_abble
scramble14177253scr_amble
screwballs1772453screwballs
screwlike1843303screwlike
scribble14175433scr_ibble
scrubbable1562113scrubbable
seeable91113943s__eeable
servable13310093ser_vable
severable1438543severable
shareable1436733share_able
shedable1437423s_hedable
showable1636583s_howable
sizeable1937113size_able
sorbable1239303sor_bable
sortable10312483sor_table
sowable121610753s__owable
spareable1337263spare_able
spreadable1544423spreadable
steerable1146913steerable
stowable1337613s_towable
superable13312483superable
surfable1338443sur_fable
unchewable2044273unchewable
viewable1635223_viewable

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.440406115.9
2DLD Change Limit148641497.32620289.5
3Display Results49490.0331484.8
 (SQL Overall)178691497.79922912.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.