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

113 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
reeves9472149(None) 
beeves114615041beeves
keeves133711991keeves
peeves113814871peeves
reaves94127571reaves
reeve84121321reeve_
reeved104118711reeved
reives95723041reives
releves103914971releves
breezes18318692breezes
breves115516422breves
creeses93914622creeses
deaves105319532deaves
delves104917082delves
eaves85231992_eaves
elves85118742_elves
eves76230462__eves
feezes184412612feezes
freezes193310352freezes
greaves113311442greaves
grieves1137322grieves
heaves124120302heaves
heezes184211642heezes
helves124316062helves
keeve124512132keeve_
leaves94222382leaves
levees93714522levees
nerves94216192nerves
neves87021872_neves
nieves94311292nieves
peeve104915252peeve_
peeved124112892peeved
pelves114514662pelves
raves85441972r_aves
reales64934122reales
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reavers108320742reavers
rebbes10313532rebbes
recces10614912recces
recedes102816062recedes
receives1339742receives
redes65139132r_edes
redeyes112910972redeyes
redoes74623772redoes
redyes104214092redyes
reeded84022562reeded
reeds65430902ree_ds
reefed103816582reefed
reefer93314362reefer
reefers103312592reefers
reefs85121662ree_fs
reeked113717642reeked
reeker103715592reeker
reekers113613142reekers
reeks94124032ree_ks
reeled74725532reeled
reeler63822572reeler
reelers73520272reelers
reels55333262ree_ls
rees45364192r_e_es
reests64618892reests
reevokes15375992reevokes
reges65628792r_eges
regives115014212regives
reive85522942reive_
reived104518132reived
reiver95318292reiver
reivers105117082reivers
releve95116402releve_
relies65036422relies
relieves114210392relieves
relives104619442relives
removes124514712removes
reneges82513592reneges
rentes65431192rentes
repaves123513652repaves
resees63827482resees
reserves111011982reserves
reshes94124362reshes
retenes76324622retenes
reties65436192reties
reuses66025522reuses
revel84423162r_evel
revels94220572revels
reveres103621342reveres
revers94529632revers
revest94623602r_evest
revet84938842r_evet
revets94022172revets
revives134715542revives
revs75027052r_ev_s
revues9813902revues
revved13469722revved
reweaves1436602reweaves
rexes124526952r_exes
rhemes115913182rhemes
riever94811652riever
rievers104311452rievers
rives85336002r_ives
roves84834482r_oves
selves94119612selves
serves94423652serves
sheeves133911952sheeves
sieves93216002sieves
sleeves103311342sleeves
steeves103410902steeves
unreeves11106162unreeves
verves124617882verves
weaves123616372weaves
weever123811442weever
weevers13379992weevers

Search took 4 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 Limit825511132.76629844.9
3Display Results1131130.0303766.7
 (SQL Overall)1786911133.13956926.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.