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

136 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
yeahs11521455(None) 
yeah106725411yeah_
yeans86624881yeans
years84527671years
yeas78638421yea_s
yechs136112581yechs
aahs716428562_aahs
ahs68644822__ahs
amahs107819062amahs
ayahs116813522ayahs
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
beths105519222beths
blahs105616512blahs
dahs88231812_dahs
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deash95617242deash
deaths105914442deaths
ears46356592_ears
eats47054872_eats
edhs86212102_edhs
eths76619522_eths
eyas76427432eya_s
eyass84410782eyass
fears84829392fears
feats86432752feats
fehs106522382fe_hs
gears64628692gears
gerahs1039412gerahs
hahs108333362_hahs
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heaths126316382heaths
heats85838402heats
hehs106723962he_hs
heths116317782heths
jeans126022112jeans
keas86337092kea_s
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
leash85519212leash
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
meths105320232meths
mynahs14416442mynahs
neaps75618322neaps
nears55529422nears
neats55931902neats
obeahs1135862obeahs
odahs95610082odahs
opahs105411982opahs
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
pechs125516202pechs
pehs95625762pe_hs
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
selahs9313212selahs
shahs115919512shahs
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
techs106915832techs
teths85418512teths
veals84926192veals
weals85428742weals
weans85326742weans
wears86030302wears
yags86632292y_ags
yah99046352y_ah_
yaks116025202y_aks
yams95330732y_ams
yaps95933522y_aps
yaws105531212y_aws
yays105728912y_ays
yea66445752yea__
yean75834582yea_n
year76534252yea_r
yearn86316432yearn
yearns9509542yearns
yeast85327942yeast
yeasts96413052yeasts
yecchs16414952yecchs
yech127220532yech_
yechy16519082yechy
yeggs10608162yeggs
yeh97135772ye_h_
yelks126413622yelks
yells85821942yells
yelps105712992yelps
yens75832262ye_ns
yeps95924402ye_ps
yerks125416562yerks
yes66250612ye__s
yeses85119322yeses
yetis85418392yetis
yetts86715132yetts
yeuks125110092yeuks
yews105323962ye_ws
yodhs12669012yodhs
yoghs125410592yoghs
yuans84613322yuans
zeals145320852zeals

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 Limit538001361.56034487.2
3Display Results1361360.0462956.5
 (SQL Overall)1786911361.91993116.7
 
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.