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 “reused” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
reused7541956(None) 
recused104714421recused
refused115114441refused
reuse56025361reuse_
reuses66025521reuses
roused75426441roused
abused95614272abused
amused94412512amused
aroused84914342aroused
bemused1236712bemused
boused95322882boused
bused85624492_bused
caused95117042caused
ceased94920782ceased
censed94016322censed
cessed94615612cessed
creased104315582creased
defused125211092defused
deuced104112122deuced
doused84821162doused
dressed93511872dressed
eased65430402_eased
erased74816752erased
feased105718712feased
fessed104515062fessed
feuded114010002feuded
feued94715662feu_ed
fused94820442_fused
greased93812392greased
groused94712832groused
housed105624102housed
jessed144112302jessed
leased74722882leased
lensed74015472lensed
loused74822912loused
mensed93916542mensed
messed95018182messed
moused94423302moused
mused85524582_mused
paused95114962paused
peised94817682peised
perused103112182perused
pressed103317302pressed
raised76120332raised
rased65033932r_ased
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
rebred95816352rebred
rebuked14438342rebuked
rebuses94915292rebuses
recked134821802recked
recuse85519162recuse_
recuses94619462recuses
redded94019542redded
reded74829112re_ded
reduced11610322reduced
redyed114611232redyed
reed55549622re__ed
reeded84022562reeded
reefed103816582reefed
reeked113717642reeked
reeled74725532reeled
reested82916232reested
reeved104118712reeved
refed93921922re_fed
refeed104717622refeed
reffed134712512reffed
refuged125410872refuged
refuse94817512refuse_
refuser104912782refuser
refuses104918552refuses
refuted114313802refuted
rehoused1239612rehoused
reined74425522reined
reived104518132reived
relied74926232relied
relumed1069812relumed
remised103516842remised
rended84524102rended
rented74426592rented
repled93319772repled
reposed103616272reposed
repped114616722repped
repulsed1136562repulsed
reputed104613482reputed
reseda739702re_seda
resee54336332re_see
reseed74823292reseed
resend75016772re_send
reset55051862re_set
resew84519502re_sew
resid64124092re_sid
resod64720052re_sod
rested74430782rested
resumed10310622resumed
retied75924982retied
retted74826312retted
retuned86613972retuned
retuse66617222retuse_
revised113815482revised
revulsed1235442revulsed
revved13469722revved
rewed95425452re_wed
rhuses94911792rhuses
rinsed75016352rinsed
roosed75621592roosed
rosed65930342r_osed
rouged86717322rouged
rouped95717352rouped
rouse56634702rouse_
rouser65224082rouser
rouses65436282rouses
rousted84013322rousted
routed75624332routed
rued55729792r_u_ed
ruled65822522r_uled
ruse45938932r_use_
ruses56136582r_uses
rushed104419862r_ushed
rusted75020922r_usted
seised74218122seised
sensed73918162sensed
soused74822982soused
teased74721152teased
tensed74817832tensed
toused74122012toused
tressed83714252tressed
unused72012882unused
used55722822__used
versed104515512versed
yessed104511162yessed
yeuked14456232yeuked

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511342.56332208.7
3Display Results1341340.0433116.3
 (SQL Overall)1786911342.71665792.0
 
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.