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

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

116 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
riverbed1424514(None) 
reverbed14269221reverbed
riverbeds15243071riverbeds
diverged14256882diverged
diverted13199582diverted
livered113111632liver_ed
liveried1238732liveried
overbed132811852_overbed
proverbed1743812proverbed
revered112819332rever_ed
reversed122711612reversed
reverted122714712reverted
riverhead1642992riverhead
riverweed1643052riverweed
riveted11258572rive_ted
rivetted12226092rivetted
adverted1336103adverted
averred11237593_averred
averted112211613_averted
caverned1436163caverned
covered133315293cover_ed
diverge12347643diverge_
diverges13258313diverges
diverse11429993diverse_
diverter12238623diverter
divested13268213divested
divorced1544313divorced
driveled1374973drive_led
drivelled1443983drivelled
everted112711853_everted
fevered14339723fever_ed
fibered1337643fiber_ed
governed1335193governed
havered144011453haver_ed
herbed123513453__herbed
hovered143411573hover_ed
interbed112413103interbed
inversed12269283inversed
inverted122312163inverted
kerbed13339703__kerbed
levered114212303lever_ed
linebred1144963linebred
livened11238933live_ned
liveries11314373liveries
mitered103213233miter_ed
obverted1435103obverted
overbet122716063_overbet
overbid132710273_overbid
overbred1459853_overbred
overed102216623_over_ed
overfed142510253_overfed
pierced12347593pi_erced
quivered2144823quiver_ed
raveled114113633rave_led
ravelled12419783ravelled
ravened115012283rave_ned
rebred95816353r__ebred
refereed12149693refereed
referred1297833referred
remerged12149173remerged
reperked15177793reperked
reserved121010583reserved
resorbed1138533resorbed
revealed123211213revealed
reveled113917753reve_led
revelled123712743revelled
revenged1337553revenged
revenued1237223revenued
reverb113912573reverb__
reverbs12368863reverb_s
revere94621253rever_e_
reverend12288853reverend
reverer103815833rever_er
reveres103621343rever_es
reverie103615163reverie_
reveries112518513reveries
reverse103913743reverse_
reverser113010483reverser
reverses112513513reverses
reverter114812873reverter
revested122612243revested
revetted122210943revetted
rezeroed1835993rezeroed
ribbed114014373ri__bbed
ripened1038203ripe_ned
rivaled1138933riv_aled
rivalled1236093rivalled
rived94825613riv___ed
river85731693river___
riverbank1842533riverbank
riverboat1444233riverboat
riverheads1742743riverheads
riverine11310803riverine
riverless1244943riverless
rivers94626543river__s
riverside1344913riverside
riverward1643443riverward
riverweeds1742243riverweeds
riveter10208753rive_ter
riviere1036373rivier_e_
rivieres1136013rivier_es
rogered939553roger_ed
severed113513863sever_ed
shivered15177103shiver_ed
silvered12237563silver_ed
slivered12218103sliver_ed
tierced10347053ti_erced
tiered73613973ti_er_ed
traversed1344563traversed
unversed122310433unversed
verbid122311313__verbid
verged114815163__verged
versed104515523__versed
viverrid1543013viverrid
waterbed1436443waterbed
wavered142910433waver_ed

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 Filter1786911461620.500357382.0
2DLD Change Limit1461621167.01620832.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.56223630.1
 
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.