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

227 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
revive124914821revive
regive104814322regive
reif76937652re_i_f
reive85522942re_ive
relief94419682relief
relive95120782relive
review1238692review
revile94921612revile
revise94019742revise
revival1337032revival
revived144211652revived
reviver134411372reviver
revives134715542revives
revivify2042922revivify
belief115018603belief
belive115415303belive
bevies114017303bevies
brevier1237763brevier
brevity1534783brevity
crevice1436153crevice
derive103817043derive
device124512163device
devil94714733devi_l
devils104412813devils
devise104215753devise
ervil8310303ervi_l
ervils948773ervils
evict104417143_evict
evil75318073_evi_l
evils84114263_evils
evite85317683_evite
kevil12399863kevi_l
kevils13358333kevils
levied104111433levied
levier94013873levier
levies93919863levies
levin84816413levi_n
levins94514653levins
levis85818553levi_s
levity1277903levity
neif75429493ne_i_f
nevi75116423nevi__
predive13511083predive
preview1536473preview
previse123713793previse
ravin85624653ravi_n
ravine95522223ravine
raving105128853raving
ravins94622563ravins
ravish123414033ravish
reave84528023re_ave
reaving113820533reaving
rebid85121363rebi_d
rebids94015533rebids
rebill84713253rebill
rebind94416933rebind
rebuff1437023rebuff
receive1239733receive
recipe103414893recipe
recit75235103reci_t
recite83625113recite
recits83621353recits
redia65524483redi_a
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393redi_d
reding83825563reding
redip87816963redi_p
redips93713843redips
redipt94116743redipt
redrive112410563redrive
reef74938213re__ef
reeve84121323re_eve
reeving113717663reeving
ref66053293re___f
refile95122373refile
refill94514053refill
refilm114311403refilm
refind104717073refind
refine95225693refine
refire95419473refire
refit84230063refi_t
refits94017653refits
refix155212483refi_x
regave104713383regave
regild8149773regild
regilt71217493regilt
regime95313943regime
regina75317143regina
region74614903region
regius7311923regius
regiven11478323regiven
regives115014213regives
rehire95415863rehire
rei35647253re_i__
reifs84819093re_ifs
reify114814973re_ify
reign65015193re_ign
rein46040893re_i_n
reink95518093re_ink
reins56234563re_ins
reis45343233re_i_s
reived104518133reived
reiver95318293reiver
reives95723043reives
reiving113316843reiving
rejig133810123reji_g
rejigs14368093rejigs
releve95116403releve
relic74623363reli_c
relics84517903relics
relict83623903relict
relied74926233relied
reliefs10439433reliefs
relier65826183relier
relies65036423relies
relieve105010693relieve
relievo10425773relievo
reline65434353reline
relink104415923relink
relish93916953relish
relist64628413relist
relit55340683reli_t
relived115114683relived
relives104619443relives
remind94819793remind
remint85329983remint
remise84221953remise
remiss84216353remiss
remit75737223remi_t
remits85622943remits
remix145916553remi_x
remixt155014853remixt
remove116115573remove
renig64518913reni_g
renigs74314593renigs
renin54830033reni_n
renins64526453renins
reoil55321183reoi_l
reoils64516873reoils
repave114813873repave
repin75324703repi_n
repine85627813repine
repins84924313repins
rerig64018483reri_g
rerigs74014793rerigs
rerise64325633rerise
reroof9315003reroof
resid64124093resi_d
reside74224933reside
resids74219153resids
resift94017723resift
resign74212583resign
resile64627673resile
resin54131053resi_n
resins64528773resins
resiny94617363resiny
resist64524533resist
resit54241043resi_t
resite64128453resite
resits64725563resits
resize154117723resize
restive10315933restive
retia55326113reti_a
retial64724993retial
retie55735303reti_e
retied75924983retied
reties65436193reties
retile65929673retile
retime85321803retime
retina65023383retina
retine66237333retine
retint65633443retint
retire64927013retire
rev65336623re__v_
revamp1336013revamp
reveal94115053reveal
revel84423163rev_el
revels94220573revels
reverb113912573reverb
revere94621253revere
revers94529633revers
revert93529113revert
revery124014213revery
revest94623603revest
revet84938843rev_et
revets94022173revets
reviews1335533reviews
reviled114417923reviled
reviler104314973reviler
reviles104421353reviles
revisal1038263revisal
revised113815483revised
reviser104114663reviser
revises104220533revises
revisit10311373revisit
revisor10388733revisor
revivals1435433revivals
revivers14389633revivers
reviving152910503reviving
revoice12319183revoice
revoke135216243revoke
revolt9316223revolt
revolve13328373revolve
revote94917453revote
revs75027053re__vs
revue81114453rev_ue
revues9813903revues
revuist1038473revuist
revved13469723revved
revving14379343revving
rewin85623963rewi_n
rewind104715883rewind
rewins95020823rewins
rewire95421413rewire
rewove126420083rewove
rexine134719443rexine
rif65951563r__i_f
riff104430103r__iff
rive75537723r__ive
riving104521423riving
roving103618743roving
seif75638733se_i_f
serif84132133seri_f
viva106119093__viva
vive105426623__vive

Search took 7 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 Filter1786911127160.403443402.0
2DLD Change Limit1127162275.56320261.7
3Display Results2272270.0633603.2
 (SQL Overall)1786912276.02929638.6
 
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.