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

118 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
leery8591913(None) 
beery105220121beery
eery76129621_eery
leary85927381leary
leer46239351leer_
leers54828981leers
peery105719441peery
veery115816251veery
aery77231682_aery
apery106517902apery
beefy135313832beefy
beer65635992beer_
beers75628392beers
berry104521762berry
bleary115112552bleary
celery1139622celery
cheery144913152cheery
deary95826842deary
decry115514352decry
deedy104315892deedy
deer56739022deer_
deers64930522deers
derry94721372derry
eely77725212_eely
elegy939302elegy
emery104814332emery
every115215452every
eyry106315882_eyry
faery116015482faery
ferry116020802ferry
fiery114714792fiery
fleecy14266482fleecy
fleer86020772fleer_
fleers96015792fleers
fleury12417352fleury
geeky134710732geeky
gleety10479192gleety
henry114014472henry
herry114922472herry
jeer115426462jeer_
jeers124818132jeers
jerry155016182jerry
kerry124916092kerry
leady95618602leady
leafy116316212leafy
leaky125217722leaky
lear47045952lear_
learn55322662learn
lears55938732lears
leavy115715772leavy
lechery15257642lechery
ledgy105712012ledgy
lee36068142lee__
leech104913212leech
leek85331732lee_k
leeks95318892leeks
leered73816222leered
leerily1037632leerily
lees45455882lee_s
leet45957902lee_t
leets54927122leets
leeway1255882leeway
lefty115613562lefty
leger65721502leger_
legers74518312legers
leggy105210242leggy
lehr75514942lehr_
lehrs86111132lehrs
leper74820742leper_
lepers84817322lepers
lever85125162lever_
levers94621322levers
levy106418502l_evy
ley66246812l_e_y
lezzy16608082lezzy
lier45942462lier_
liers55130402liers
livery124910892livery
lorry86315662lorry
lory75931712l_ory
loury85716752loury
lowery124112702lowery
merry104721482merry
needy94614692needy
onery8414112onery
peer66238352peer_
peers75130272peers
perry105222712perry
query174212082query
redry94314362redry
reedy910020282reedy
reefy114217702reefy
reeky125416262reeky
refry114412462refry
retry84718082retry
revery124014212revery
seedy94821532seedy
seely84522632seely
seepy104717972seepy
seer45547042seer_
seers55136382seers
serry84824122serry
sleeky13398962sleeky
sleepy11479412sleepy
sleety94112652sleety
sneery93610412sneery
teary85124052teary
teeny85417882teeny
terry84721872terry
veer76229572veer_
veers84521362veers
venery123710662venery
very108025642_very
weary115620612weary
weedy125115002weedy
weeny115316162weeny
weepy134212592weepy
weer75535092weer_

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.0931921408.6
2DLD Change Limit538001181.67332157.8
3Display Results1181180.0303933.3
 (SQL Overall)1786911181.79699493.9
 
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.