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

185 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
replacer1227974(None) 
replace113214281replace_
replaced133211401replaced
replacers13266831replacers
replaces123114121replaces
placer105117742__placer
preplace1488982preplace_
preplaced1676482preplaced
preplaces1578752preplaces
relace83122152re_lace_
relaced103517212re_laced
relaces93420882re_laces
relater73723142re_later
relaxer143410222re_laxer
repaper11310022rep_aper
repealer103210702repealer
repeater102615442repeater
replaster1136582replaster
replate93420052replate_
replated112817522replated
replates102919272replates
replayed14248632replayed
repleader1245392repleader
replier94214972repl_ier
retracer101411882retracer
belaced124112153be_laced
belayer12339503be_layer
cellarer10317923cellarer
declarer1148063declarer
defacer132810363de_facer
deflater123211603deflater
delayer113010533de_layer
deplane10311413deplane_
deplaned1238663deplaned
deplanes11311213deplanes
depleter11298863depleter
deplorer1136343deplorer
deployer1445633deployer
depraver1435413depraver
displacer1446433displacer
effacer15255413_effacer
elater64724203_e_later
emplace1338263emplace_
emplaced1536053emplaced
emplaces1438413emplaces
enlace82213233_enlace_
enlaced102410523_enlaced
enlaces92313393_enlaces
fireplace1644873fireplace_
fireplaced1842943fireplaced
fireplaces1744343fireplaces
freelancer1553333freelancer
kreplach1942613kreplac_h
lacer75833753___lacer
menacer112610883me_nacer
noplace1137393noplace_
pacer96131613__p_acer
place94824613__place_
placed114318003__placed
placers114515263__placers
places104323703__places
placet103923673__placet
planer84122653__planer
plater84427693__plater
player115215213__player
prefacer1537983pre_facer
preparer12169643prep_arer
racer75233023r___acer
reacher123718293re__acher
reader73628293re__ader
realer63528593re__aler
realiser82512563realiser
realizer172412113realizer
realter73716313real_ter
reamer84325213re__amer
reaper84223143re__aper
rearer64928913re__arer
reaver94524733re__aver
rebater93517913re_bater
recaller1039323recaller
reclaimer1344463reclaimer
reclame11411063reclame_
reclames12310893reclames
recliner103211913recliner
redliner93510473redliner
redrawer1235313redrawer
reducer1059003re_ducer
reeler63822573reel__er
reface113616353re_face_
refaced133713573re_faced
refaces123216743re_faces
reflate103516263reflate_
reflated123514293reflated
reflates113115663reflates
reflower14126843reflower
regaler83814623re_galer
reglaze1747223reglaze_
reglazed1935743reglazed
reglazes1846793reglazes
reheater113413033reheater
rejoicer17315343rejoicer
relabel938163re_label
relacquer2042193re_lacquer
relapser1035273re_lapser
relate64033633re_late_
related83327573re_lated
relaters83218153re_laters
relates73731433re_lates
relator74016363re_lator
relaxed153312533re_laxed
relaxers15298263re_laxers
relaxes143215323re_laxes
relayed113212753re_layed
releaser839503releaser
relier65826183re_l_ier
reloader937913reloader
remaker133813173re_maker
repack142412163rep_ac_k
repacked17188743rep_acked
repacks15269543rep_acks
repair84011463rep_a_ir
repairer1036783repairer
repanel939963rep_anel
repapers1258833rep_apers
repave114813873rep_ave_
repaved133311133rep_aved
repaves123513653rep_aves
repealed113211873repealed
repealers11278843repealers
repeated113117443repeated
repeaters112811993repeaters
repeller103010393repeller
repenter102813863repenter
repiner94816903rep_iner
replacing142210163replacing
replan83215823repla__n
replanned1235163replanned
replans92814943repla_ns
replant93318533repla_nt
replanted1248063replanted
replants102811243replants
replasters1245533replasters
replay113412923repla__y
replays12399763repla_ys
repleaded1336293repleaded
repleaders1344033repleaders
repled93319783repl__ed
replete92912993replete_
repletes102812473repletes
replica1137943replic_a
replicas1237093replicas
replicon1244323replicon
replied103914453repl_ied
repliers103710163repl_iers
replies94521043repl_ies
replowed14127573replowed
reporter10411423reporter
reposer93715333rep_oser
repower12329883rep_ower
reprice113212833reprice_
repriced132610543repriced
reprices122913353reprices
reproacher1764273reproacher
reprover13229203reprover
repulser1035803repulser
reshaper1336913reshaper
reslate73520593reslate_
reslated93517523reslated
reslates83619503reslates
respace11310913respace_
respaced1338503respaced
respaces12311043respaces
resplice1237253resplice_
respliced1445543respliced
resplices1336623resplices
retaker113714313re_taker
retrace91417343retrace_
retraced111413023retraced
retracers11149553retracers
retraces101417273retraces
revealer113110073revealer
solacer93011103_solacer
spacer104917793_sp_acer
splicer114710523_splicer
unplaced1338613unplaced

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621856.80021494.4
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.29624491.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.