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

93 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
resprays134471(None) 
respray1236501respray_
estrays10529402_estrays
repays113813972re_p_ays
replays12399762re_plays
resays93714152res__ays
respeaks1434952respeaks
resprang11175842resprang
resprayed1544352resprayed
respreads1244522respreads
sprays115913642__sprays
bespeaks1643963bespeaks
bespreads1443503bespreads
betrays12127823be_trays
bewrays15145113be_wrays
cesuras958693cesura_s
defrays1436113de_frays
derays105514253de__rays
destroys1236693destroys
displays1446293displays
espials937093_espials
esprits938393_esprits
essays965653_es_says
estray95713333_estray_
misplays1555543misplays
ospreys1233143_ospreys
outprays13236933outprays
prays105022433___prays
prepays1437483pre_p_ays
redbays1336013re_dbays
redisplays1651593redisplays
redraws11218473re_draws
relays94316753re__lays
remoras9314073remora_s
reparks13249513re_parks
repass84114703re_p_ass
repay104818453re_p_ay_
repeals94014523re_peals
repeats94316053re_peats
replans92814943re_plans
replay113412923re_play_
repress92712683re_press
repros84216003re_pr_os
resaws93713513res__aws
resay85320543res__ay_
reseals73917663res_eals
reseats74319583res_eats
reseaus74012153res_eaus
resedas839123reseda_s
reserves111011983reserves
resoaks1148973res_oaks
resorbs95010523resor_bs
resorts74817193resor_ts
respace11310913resp_ace
respaces12311043respaces
respade1039573resp_ade
respades1139853respades
respeak1335933respea_k
respects1247703respects
respells1056333respells
respires10311903respires
respites10513243respites
resplits1037723resplits
responds1136913responds
respools1036243respools
respots92912763resp_ots
respraying1636093respraying
respread1135433respread
respring111614063respring
resprings12156253resprings
resprout1078783resprout
resprouts1174823resprouts
resprung11164103resprung
restarts8310873restarts
restorals978073restorals
restrain8311703restrain
restrains9311623restrains
restress82511773restress
resurges9310123resurges
resurveys1542683resurveys
rewraps12136563re_wraps
ripraps1134943r_ipraps
ristras7311563ristra_s
rosebays13114903rosebays
spays105520513__sp_ays
splays114910873__splays
sprags95715823__sprags
sprats85819933__sprats
spray106720063__spray_
strays96417933__strays
trespass1043383tresp_ass
vesperals1443933vesperals
whiprays1942503whiprays

Search took 9 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 Filter1786911461620.190940478.9
2DLD Change Limit146162938.51317169.3
3Display Results93930.0462021.7
 (SQL Overall)178691938.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.