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 “evert” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
evert8492951(None) 
avert86029491avert
event85924441event
ever77027691ever_
everts94514891everts
every115215451every
exert124624141exert
overt85630721overt
revert93529111revert
vert77249371_vert
advert103215782advert
alert54740652alert
aver75931882aver_
avers85127312avers
averts95715242averts
chert105232102chert
covert114925502covert
desert72725492desert
devest104418702devest
divert103922812divert
eery76129622e_ery
eger55923572eger_
egers65120372egers
egest65222342egest
egret63327312egret
eject145016042eject
elect74327032elect
elver85216242elver_
elvers93814982elvers
emery104814332emery
erect74129332erect
eve66331162eve__
even75222272eve_n
evens84817102evens
events94814072events
everted112711852everted
evertor1038722evertor
eves76230462eve_s
evict104417142evict
ewer77523982ewer_
ewers86018822ewers
exerts133712292exerts
expert15515352expert
exsert13414362exsert
eyer76127282eyer_
eyers86521332eyers
fever115617952fever_
fevers125414892fevers
inert53234372inert
invert94120082invert
lever85125162lever_
leveret103014002leveret
levers94621322levers
never86218642never_
obvert11412992obvert
over77227342over_
overs85224792overs
pert66759322_pert
pervert12315582pervert
reverb113912572reverb
revere94621252revere
revers94529632revers
reverts104715042reverts
revery124014212revery
revest94623602revest
revet84938842reve_t
sever85426052sever_
severe94016082severe
severs94121122severs
sievert10613292sievert
veer76229572veer_
veers84521362veers
veery115816252veery
vent76049052_vent
vera76828842_vera
verb96224872_verb
verst84429372_verst
verts85724732_verts
vertu85017612_vertu
very108025642_very
vest75743602_vest
vet65958522_ve_t
vext146927762_vext
wert79749822_wert

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800841.53035163.4
3Display Results84840.0332545.5
 (SQL Overall)178691841.87695251.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.