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

117 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
remate8442868(None) 
cremate113816181cremate
ramate83921681ramate
rebate84424111rebate
redate74124681redate
relate64033631relate
remade94316981remade
remake124016111remake
remated103522471remated
remates93827111remates
remote84222601remote
aerate64830552aerate
agemate101210582agemate
bedmate1239432bedmate
bemata10411692bemata
berate84729022berate
bregmate1345532bregmate
bromate11313552bromate
cerate84829462cerate
comate104124842comate
create85126372cre_ate
cremated133412962cremated
cremates124216002cremates
crenate93317112crenate
crewmate15405622crewmate
debate94419192debate
delate73827752delate
demote94817802demote
derate74531232derate
elate55335882_elate
emote75421192_emote
enate54428142_enate
eremite9312832eremite
ergate7315142ergate
female11310552female
fermate122813002fermate
gelate73421252gelate
gemmate12418382gemmate
gemote94613022gemote
hamate113319832hamate
humate113214442humate
inmate82917362inmate
legate72917452legate
mate65154212__mate
metate82720532metate
negate72915572negate
pedate93117762pedate
predate10616892predate
prelate9519692prelate
premade12311442premade
primate111516282primate
racemate1239062racemate
rate45458762r__ate
reata54225392re_ata
reave84528022re_ave
rebated103619702rebated
rebater93517912rebater
rebates95123182rebates
rebato83714682rebato
recane83022872recane
recite83625112recite
recrate92621652recrate
redated93120922redated
redates83423872redates
reface113616352reface
reflate103516262reflate
refute95515702refute
regale74821452regale
regave104713382regave
regmata1036192regmata
regrate82618662regrate
reimage1037912reimage
relace83122152relace
related83327572related
relater73723142relater
relates73731432relates
remail85017122remail
remain85919862remain
remaker133813172remaker
remakes134116172remakes
reman75730152rema_n
remand95618962remand
remans84823002remans
remap95418102rema_p
remaps105012872remaps
remark123512372remark
remaster10311472remaster
rematch1436192rematch
remeet86325472remeet
remet74843722remet_
remise84221952remise
remit75737222remit_
remits85622942remits
remoter94815972remoter
remotes94521612remotes
remove116115572remove
rename82718812rename
rente54733782re_nte
repave114813872repave
replate93420052replate
repute84716092repute
resale64025542resale
resat55139682resat_
resite64128452resite
reslate73520592reslate
restate73824882restate
retake104718532retake
retape83917682retape
retaste72313132retaste
rete44944132re__te
revote94917452revote
rewake135218462rewake
rotate63320342rotate
rugate75813812rugate
sedate73019802sedate
senate63725142senate
velate93720142velate

Search took 6 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.1261418182.5
2DLD Change Limit825511175.26615676.2
3Display Results1171170.0761539.5
 (SQL Overall)1786911175.46832679.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.