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

78 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
resprayed154435(None) 
estrayed1236392_estrayed
replayed14248622re_played
respaced1338502resp_aced
respaded1238132resp_aded
respray1236502respray__
resprays1344712respray_s
sprayed13398902__sprayed
unsprayed1554362unsprayed
betrayed1436303be_trayed
bewrayed1733933be_wrayed
defrayed1635403de_frayed
depraved1535543de_praved
destroyed1445083destroyed
displayed1645883displayed
essayed1134013_es_sayed
misplayed1745303misplayed
outprayed1545753outprayed
prayed124815433___prayed
recrated112918603re_crated
redisplayed1851613redisplayed
reframed1437853re_framed
regraded113410763re_graded
regrated102816333re_grated
relayed113212753re__layed
reoperated1348153reoperated
reparked15208923re_parked
repaved133311133re_p_aved
repealed113211873re_pealed
repeated113117443re_peated
rephrased1555283rephrased
replaced133211393re_placed
replated112817513re_plated
repriced132610543re_priced
reprised112012203re_prised
reprobed13228743re_probed
reproved14199473re_proved
resawed113111183res__awed
rescaled113311303res_caled
resealed92713963res_ealed
reseated93220263res_eated
reserved121010583reser_ved
reshaped1437203res_haped
reshaved1536873res_haved
resinated10413283resinated
reslated93517523res_lated
resoaked1337943res_oaked
resonated10510613resonated
resorbed1138533resor_bed
resorted9313493resor_ted
respace11310913resp_ace_
respaces12311043resp_aces
respade1039573resp_ade_
respades1139853resp_ades
respected1438493respected
respelled1257033respelled
respired1148993resp_ired
respited11410813resp_ited
respliced1445533respliced
responded1336513responded
respooled1245593respooled
respotted1235953respotted
resprang11175843respra_ng
respraying1636093respraying
respread1135433respr_ead
resprouted1344223resprouted
restaged103011863res_taged
restarted10410053restarted
restated93120183res_tated
restrained1148413restrained
resurfaced1642463resurfaced
resurged1038623resur_ged
resurveyed1742053resurveyed
retraced111413023re_traced
spayed124213613__sp_ayed
splayed13357813__splayed
sprayer12369043__sprayer
strayed114513283__strayed

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 Limit148641787.08020994.5
3Display Results78780.0302600.0
 (SQL Overall)178691787.26624592.8
 
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.