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

166 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
reives9572304(None) 
reaves94127571reaves
reeves94721491reeves
regives115014211regives
reive85522941reive_
reived104518131reived
reiver95318291reiver
reivers105117081reivers
relives104619441relives
revives134715541revives
rives85336001r_ives
arrives101311512arrives
beeves114615042beeves
beiges91014412beiges
bevies114017302bevies
breves115516422bre_ves
chives144317592chives
deaves105319532deaves
deices94119372deices
delves104917082delves
derives114017812derives
dives95832402_dives
drives105117112drives
eaves85231992_eaves
elves85118742_elves
eves76230462_e_ves
fives116027362_fives
gives95324872_gives
greaves113311442greaves
greiges937732greiges
grieves1137322grieves
heaves124120302heaves
helves124316062helves
hives116925512_hives
jives154820812_jives
keeves133711992keeves
knives13458552knives
leaves94222382leaves
levies93919862levies
lives86133192_lives
naives94914222naives
nerves94216192nerves
neves87021872ne_ves
nieves94311292nieves
ogives10367912ogives
olives94313952olives
oreides8312022oreides
peeves113814872peeves
peises84125042peises
pelves114514662pelves
prelives13310382prelives
raises64826542raises
raves85441972r_aves
reales64934122reales
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reavers108320742reavers
rebbes10313532rebbes
recces10614912recces
receives1339742receives
recipes113314462recipes
recites93524582recites
redes65139132re_des
redoes74623772redoes
redrives122610392redrives
redyes104214092redyes
rees45364192re__es
reeve84121322reeve_
reeved104118712reeved
refiles104122422refiles
refines105426342refines
refires104820312refires
refixes174813172refixes
reges65628792re_ges
regimes104514742regimes
regive104814322regive_
regiven11478322regiven
rehires105016112rehires
reifies104218282reifies
reifs84819092rei_fs
reigns74811752reigns
reined74425522reined
reinks105012152reinks
reins56234562rei_ns
reinvest1138202reinvest
reis45343232rei__s
releves103914972releves
relies65036422relies
relieves114210392relieves
relines75331322relines
relive95120782relive_
relived115114682relived
remiges103015472remiges
remises93423482remises
remixes164313872remixes
removes124514712removes
rentes65431192rentes
repaves123513652repaves
repines94927382repines
rerises73525882rerises
resees63827482resees
reshes94124362reshes
resides84523282resides
resiles74026542resiles
resites74027792resites
resizes164216842resizes
reties65436192reties
retiles74426992retiles
retimes95020172retimes
retines75134672retines
retires74726212retires
reuses66025522reuses
revel84423162re_vel
revels94220572re_vels
revers94529632re_vers
revest94623602re_vest
revet84938842re_vet
revets94022172re_vets
review1238692review
reviews1335532reviews
reviles104421352reviles
revise94019742revise
revises104220532revises
revive124914822revive_
revived144211652revived
reviver134411372reviver
revivers14389632revivers
revs75027052re_v_s
revues9813902revues
revved13469722revved
rewires104717112rewires
rexes124526952re_xes
rexines144719152rexines
ribes75530172r_ibes
rices75536152r_ices
rides66140812r_ides
riever94811652riever
rievers104311452rievers
riles55343642r_iles
rimes75634542r_imes
ripes75435772r_ipes
rises55244042r_ises
rites54442552r_ites
rive75537722r_ive_
rived94825612r_ived
riven85121622r_iven
river85731692r_iver
rivers94626542r_ivers
rivet85636362r_ivet
rivets94417112r_ivets
roves84834482r_oves
seines65029902seines
seises64026712seises
seizes154317532seizes
selves94119612selves
serves94423652serves
shives124921412shives
sieves93216002sieves
skives134113942skives
swives123915182swives
ureides8311102ureides
verves124617882verves
waives123714182waives
weaves123616372weaves
wives115328922_wives

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 Filter178691825511.250142952.8
2DLD Change Limit825511666.11013510.8
3Display Results1661660.0463608.7
 (SQL Overall)1786911667.40624127.9
 
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.