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

48 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
unscrewed155403(None) 
uncrewed1456761un_crewed
screwed135710662__screwed
unchewed1735802un_chewed
unscreened1343372unscreened
unscrew1245462unscrew__
unscrews1343312unscrew_s
unsewed112911022uns__ewed
beshrewed1882723beshrewed
bestrewed1594163bestrewed
crewed125316563___crewed
eschewed1743443_eschewed
escrowed1434653_escrowed
inscribed1444213inscribed
onscreen1044253onscre_en
screed95718933__scre_ed
screwer124410073__screwer
shrewed14589853__shrewed
strewed115811343__strewed
sunscreen1142943sunscre_en
unagreed1036823unagre_ed
unceded11410563un_c_eded
unclawed1457983un_clawed
uncrated11416313un_crated
uncreated12312303un_created
uncrowded1654133un_crowded
uncrowned1564743un_crowned
unfreed11510123un_fre_ed
unmewed13258173un__mewed
unrenewed1344233unrenewed
unsawed112911503uns__awed
unscaled111410113unsc_aled
unscanned1245133unscanned
unscarred1235673unscarred
unscathed1535313unscathed
unscented1237513unscented
unscrewing1643203unscrewing
unscripted1544633unscripted
unseeded1038253uns_eeded
unserved12410233unser_ved
unsexed152410253uns__exed
unsorted9312513unsor_ted
unsowed112511053uns__owed
unsphered1556103unsphered
unsprayed1554363unsprayed
unsteeled1045753unsteeled
unstressed1145083unstressed
unstriped1246303unstriped

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.470380193.6
2DLD Change Limit148641486.86021667.8
3Display Results48480.0133692.3
 (SQL Overall)178691487.34324334.9
 
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.