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

79 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
unsprayed155436(None) 
resprayed1544352resprayed
sprayed13398902__sprayed
unarrayed1344182unarrayed
unplayed1437262un_played
unstayed12168392uns_tayed
unswayed15155712uns_wayed
displayed1645883displayed
endplayed1642783endplayed
estrayed1236393_estrayed
misplayed1745303misplayed
outprayed1545753outprayed
prayed124815433___prayed
spayed124213613__sp_ayed
splayed13357813__splayed
sprayer12369043__sprayer
strayed114513283__strayed
unabraded1344893unabraded
unallayed1344073unallayed
unaspirated1444243unaspirated
unassayed1343493unassayed
unbraced132310433un_braced
unbraked15289413un_braked
uncrated11416313un_crated
undecayed1645173undecayed
underaged121011233underaged
undraped1239393un_draped
unerased9312773un_erased
unessayed1342943unessayed
unframed1478243un_framed
ungraced12239143un_graced
ungraded11209923un_graded
unpaged113311043un_p_aged
unparted11310823un_parted
unpaved133410053un_p_aved
unplaced1338613un_placed
unpriced1338143un_priced
unprimed1337203un_primed
unprized2038513un_prized
unprobed1366973un_probed
unproved1457533un_proved
unpruned1136863un_pruned
unraked122914013un__raked
unrated82621553un__rated
unrazed172511453un__razed
unsated83419933uns__ated
unsaved113312193uns__aved
unsawed112911503uns__awed
unscaled111410113uns_caled
unscarred1235673unscarred
unscrewed1554033unscrewed
unsealed91513623uns_ealed
unseamed111210663uns_eamed
unseared91113943uns_eared
unseated91317683uns_eated
unseparated1443513unseparated
unserved12410233unser_ved
unshaded13149263uns_haded
unshamed14148053uns_hamed
unshaped14148443uns_haped
unshared121510703uns_hared
unshaved15157733uns_haved
unslaked1338463uns_laked
unsnarled1035743unsnarled
unsoaked1338853uns_oaked
unsorted9312513unsor_ted
unsphered1556103unsphered
unspilled1245093unspilled
unspoiled12255563unspoiled
unspooled12254913unspooled
unspotted1244933unspotted
unsquared1944073unsquared
unstarred1036363unstarred
unstated91615813uns_tated
unstrained1146373unstrained
unstrapped1573563unstrapped
unstriped1246303unstriped
untraced112413243un_traced
uprated103213323u__prated

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.436409841.7
2DLD Change Limit148641797.20320636.0
3Display Results79790.0332393.9
 (SQL Overall)178691797.67223291.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.