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

85 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
unscrew124546(None) 
unscrews1343311unscrews
screw109318542__screw
undrew1037912un_drew
unscrewed1554032unscrewed
unsew83912692uns__ew
unsure62815412unsure_
aircrew12113913aircrew
airscrew13102933airscrew
beshrew1554393beshrew
bestrew1248003bestrew
crew96122683___crew
ensure63416003ensure_
ensured83512943ensured
ensurer73011903ensurer
ensures73315903ensures
eschew1436333_eschew
escrow1135913_escrow
insure63416603insure_
insured83714253insured
insurer73312803insurer
insures73117263insures
misdrew1335833misdrew
misgrew1335523misgrew
nacre75715363_nacre_
nacred95212493_nacred
nacres85614453_nacres
onscreen1044253onscreen
scree720031713__scree
screws115513893__screws
screwy14659463__screwy
setscrew1341963setscrew
shrew119720173__shrew
strew89220663__strew
sunscreen1142943sunscreen
unacted10312733unacted
unaired82916013unaired
unbred92613303un_bred
uncle7317053un_cle_
uncles8317163un_cles
uncrewed1456763un_crewed
uncrown1236323un_crown
uncured10513233uncured
undraw1037813un_draw
unfired112212453unfired
unfree9413203un_free
unhired112512153unhired
unmew103610073un__mew
unpure82911533unpure_
unsafe9310693unsafe_
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unscaled111410113unscaled
unscarred1235673unscarred
unscrewing1643203unscrewing
unseared91113943unseared
unsecured1244903unsecured
unseen62012623uns_een
unserved12410233unserved
unset54532433uns__et
unsewed112911023unsewed
unsewn9298393uns__ewn
unsews9379363uns__ews
unsex123512633uns__ex
unsexed152410253unsexed
unsexes14248923unsexes
unshared121510703unshared
unshed10313773uns_hed
unsicker1435303unsicker
unsized172510543unsized
unsober967643unsober
unsorted9312513unsorted
unsoured9310063unsoured
unsowed112511053unsowed
unsteel738793unsteel
unstep839223uns_tep
unstrap946783unstrap
unstress837373unstress
unsurely1146383unsurely
unswore1039053unswore_
untired82316383untired
upgrew1233653u_pgrew
upthrew1542663upthrew
usurer638103u_surer

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 Filter1786911340270.436409841.7
2DLD Change Limit134027856.36021073.4
3Display Results85850.0332575.8
 (SQL Overall)178691856.82926166.5
 
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.