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

144 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
riven8512162(None) 
driven105210141driven
given95915281given
liven85021731liven
raven84723441raven
ripen75619261ripen
risen54621881risen
rive75537721rive_
rived94825611rived
river85731691river
rives85336001rives
rivet85636361rivet
roven85521971roven
aiver85725162aiver
arisen65316792arisen
civet105828732civet
coven106925042coven
craven114113932craven
daven94916472daven
divan96114842divan
dive85634772dive_
dived106321372dived
diver94827802diver
dives95832402dives
dizen155214932dizen
doven94718552doven
drive95318002drive_
drivel105110382drivel
driver104714492driver
drives105117112drives
even75222272_even
five107629742five_
fiver116024942fiver
fives116027362fives
gien56330022gi_en
give85829352give_
givens10379732givens
giver94921202giver
gives95324872gives
graven104513522graven
grivet103517822grivet
haven114718532haven
hive106029672hive_
hived125217912hived
hives116925512hives
jive146123592jive_
jived165115042jived
jiver155119052jiver
jives154820812jives
jivey185111872jivey
lien45339802li_en
liken911818842liken
limen75426032limen
linen55728722linen
live76540992live_
lived95523722lived
livens94314892livens
liver85132962liver
lives86133192lives
maven104816892maven
mien65028362mi_en
mizen164815272mizen
oven76624142_oven
privet113821342privet
proven114314772proven
ramen75625192ramen
rave75542092rave_
raved94931432raved
ravel84621512ravel
ravens93916882ravens
raver85631492raver
raves85441972raves
ravin85624652ravin
regiven11478322regiven
reive85522942reive_
reived104518132reived
reiver95318292reiver
reives95723042reives
revel84423162revel
revet84938842revet
ribes75530172ribes
rice64942912rice_
riced85825542riced
ricer74726612ricer
rices75536152rices
richen113812512richen
ricin74620212ricin
ridden83511722ridden
ride55945132ride_
rident7520192rident
rider65231302rider
rides66140812rides
riel46432382ri_el
riever94811652riever
rife74632322rife_
rifer84721982rifer
rile45650532rile_
riled65833252riled
riles55343642riles
riley84420582riley
rime65138882rime_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
rin36663182ri__n
ripe66038922ripe_
riped85226432riped
ripens85012172ripens
riper74328402riper
ripes75435772ripes
rise45945232rise_
riser55431052riser
rises55244042rises
rite45849452rite_
rites54442552rites
rival85216502rival
rivers94626542rivers
rivets94417112rivets
riving104521422riving
rouen54920902rouen
rove75136982rove_
roved95323552roved
rover85527372rover
roves84834482roves
rowen84921152rowen
rumen74419502rumen
seven84118312seven
shriven13379652shriven
siren54525822siren
siver85728612siver
striven103910752striven
thriven13447022thriven
trivet93721882trivet
vimen104114752vimen
vive105426622vive_
vixen153010022vixen
widen94717972widen
wive105931752wive_
wived125121502wived
wiver115924512wiver
wivern12409282wivern
wives115328922wives
wizen175813862wizen
woven115215172woven

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001441.58034050.6
3Display Results1441440.0463130.4
 (SQL Overall)1786911441.93692299.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.