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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
riever9481165(None) 
griever1136031griever
liever94611861liever
reiver95318291reiver
rievers104311451rievers
river85731691ri_ver
aiver85725162ai_ver
briefer1235562briefer
clever114611532clever
dieter73516772dieter
diver94827802di_ver
driver104714492dri_ver
ever77027692__ever
fever115617952_fever
fiver116024942fi_ver
giver94921202gi_ver
grieve1047242grieve_
grieved1235282grieved
grievers1255472grievers
grieves1137322grieves
jiver155119052ji_ver
lever85125162_lever
lieder74912322lieder
liefer9529572liefer
lieve86315472lieve_
liver85132962li_ver
never86218642_never
nieve85613182nieve_
nieves94311292nieves
piecer105213082piecer
raver85631492r_aver
reaver94524732reaver
reefer93314362reefer
reeker103715592reeker
reeler63822572reeler
reeve84121322reeve_
reeved104118712reeved
reeves94721492reeves
refer84822142r_efer
reive85522942reive_
reived104518132reived
reivers105117082reivers
reives95723042reives
reliever11448682reliever
revel84423162r_evel
reverb113912572r_everb
revere94621252r_evere
revers94529632r_evers
revert93529112r_evert
revery124014212r_every
revet84938842r_evet
ribber103515492ribber
ribier84414232ribier
ricer74726612ri_cer
richer114015042richer
ridder84015142ridder
rider65231302ri_der
rifer84721982ri_fer
rifler94014262rifler
rigger85616712rigger
rimer75429242ri_mer
rimier83916272rimier
rimmer103516032rimmer
ringer74526062ringer
rinser64317212rinser
rioter64817282rioter
ripener937912ripener
riper74328402ri_per
ripper103518652ripper
riser55431052ri_ser
risker105414492risker
ritter63822422ritter
rive75537722ri_ve_
rived94825612ri_ved
riven85121622ri_ven
rivers94626542ri_vers
rives85336002ri_ves
rivet85636362ri_vet
riveter10208752riveter
rover85527372r_over
sever85426052_sever
sieve84918842sieve_
sieved104611442sieved
sievert10613292sievert
sieves93216002sieves
silver93815812silver
siver85728612si_ver
soever94412092soever
viewer1237212viewer
weever123811442weever
wiener94513542wiener
wiver115924512wi_ver

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.343520965.0
2DLD Change Limit82551922.54632423.8
3Display Results92920.0303066.7
 (SQL Overall)178691922.91961216.5
 
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.