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

151 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
relate6403363(None) 
delate73827751delate
elate55335881_elate
gelate73421251gelate
prelate9519691prelate
rebate84424111rebate
redate74124681redate
reflate103516261reflate
relace83122151relace
related83327571related
relater73723141relater
relates73731431relates
remate84428681remate
replate93420051replate
reslate73520591reslate
velate93720141velate
ablate82219212ablate
aerate64830552aerate
alate55340322_alate
areolate81014452areolate
belated103520012belated
berate84729022berate
blate75933782_blate
cerate84829462cerate
chelate122914892chelate
corelate10516012corelate
create85126382cre_ate
cremate113816182cremate
crenate93317112crenate
dealate83617842dealate
debate94419192debate
deflate113613942deflate
delated93722872delated
delates83526282delates
delete73620702delete
derate74531232derate
dilate73220692dilate
elated74725822_elated
elater64724202_elater
elates65032362_elates
elite56230182_elite
eluate62315432_eluate
elute54822572_elute
enate54428152_enate
ergate7315142ergate
fellate10313432fellate
folate93320392folate
gelated93615632gelated
gelates83219582gelates
gelati73814532gelati
gelato73812952gelato
late47560482__late
legate72917452legate
malate84624552malate
metate82720532metate
negate72915572negate
oblate82214742oblate
oleate6318882oleate
palate84226782palate
pedate93117762pedate
pelage9515362pelage
pelite84323002pelite
peltate92013772peltate
plate74635112_plate
predate10616892predate
prelates10418572prelates
prolate9419792prolate
ramate83921682ramate
rate45458762r__ate
realter73716312realter
realty92713692realty
reata54225392re_ata
reave84528022re_ave
rebated103619702rebated
rebater93517912rebater
rebates95123182rebates
rebato83714682rebato
recane83022872recane
recite83625112recite
reclame11411062reclame
recrate92621662recrate
redated93120922redated
redates83423872redates
reface113616352reface
reflated123514292reflated
reflates113115662reflates
refute95515702refute
regale74821452regale
regave104713382regave
regelate9312082regelate
reglaze1747222reglaze
regrate82618662regrate
regulate9313022regulate
relabel938162relabel
relaced103517212relaced
relaces93420882relaces
relaid75518442relaid
reland75920432reland
relapse947702relapse
relaters83218152relaters
relative11313142relative
relator74016362relator
relax124817802rela_x
relaxed153312532relaxed
relaxer143410222relaxer
relaxes143215322relaxes
relay84424672rela_y
relayed113212752relayed
relays94316752relays
release7312762release
relegate9311242relegate
relet54749822relet_
relets64025672relets
releve95116402releve
reline65434352reline
relit55340682relit_
relive95120782relive
relocate10713532relocate
relume8313272relume
remade94316982remade
remake124016112remake
remated103522472remated
remates93827112remates
remote84222602remote
rename82718812rename
rente54733782re_nte
repave114813872repave
replace113214282replace
replated112817522replated
replates102919272replates
replete92912992replete
repute84716092repute
resale64025542resale
resat55139682resat_
resite64128452resite
reslated93517522reslated
reslates83619502reslates
restate73824882restate
retake104718532retake
retape83917682retape
retaste72313132retaste
rete44944132re__te
revote94917452revote
rewake135218462rewake
rotate63320342rotate
rugate75813812rugate
sedate73019812sedate
senate63725172senate
slate55438282_slate
solate64526072solate
telae54323292tela_e

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 Limit825511512.26636430.3
3Display Results1511510.0463282.6
 (SQL Overall)1786911512.65567303.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.