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

124 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
abyes10551853(None) 
abbes96723521abbes
ables75935541ables
abye97921001abye_
abys97221881aby_s
abyss10669461abyss
ayes76543511a_yes
byes95230531_byes
abas68642082ab_as
abase76023482abase
abases85720772abases
abates85825032abates
abayas114011702abayas
abbas95918642abbas
abbe87627192abbe_
abbess10509772abbess
abbey125714932abbey
abbeys13538422abbeys
abed79734132ab_ed
abeles84719392abeles
abet610547942ab_et
abets75621672abets
abides94719892abides
able66340532able_
abled86926832abled
abler75624312abler
ablest84721832ablest
abodes94417512abodes
abos67734412ab_os
aboves114512842aboves
abris75722602abris
abs59356072ab__s
abuse77119562abuse
abuses85119102abuses
abuts75417072abuts
aby810238062aby__
abysm12598142abysm
abysms13565652abysms
abysses1234862abysses
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
acyls104211522acyls
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agues64919052agues
aides65336602aides
akees96119242akees
ales47067102a_les
almes75126542almes
aloes54933672aloes
ambles105121862ambles
amies76837692amies
amyls104512692amyls
anes45255932a_nes
antes56334322antes
apes66047432a_pes
apres75426402apres
apses76823912apses
ares45871022a_res
arles56735742arles
arses55733872arses
aryls87015812aryls
ashes86230612ashes
asses55629282asses
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
aye67151762a_ye_
ays67050292a_y_s
babes95834112babes
babies106123652babies
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
baryes116218502baryes
bases75644352bases
bates75846342bates
bayed115423022bayed
bays97143912bay_s
bees65453382_bees
bes56557432_b_es
beys913829552_beys
bye86134592_bye_
byres104421382_byres
bys85229462_by_s
bytes105217492_bytes
cables104527552cables
debyes1238102debyes
dyes85331892_dyes
eyes75837882_eyes
fables114921672fables
gabies93820732gabies
gables94222332gables
gybes115012722gybes
kyes115124932_kyes
lyes75530832_lyes
mabes96331532mab_es
maybes1339242maybes
nabes75427092nab_es
obes66036832ob_es
obeys107010642obeys
oboes75717712oboes
oyes74940132_oyes
pyes95528992_pyes
rabies85226022rabies
ryes75529352_ryes
sabes76437462sab_es
sables85026692sables
sabres85520862sabres
snyes85012752snyes
styes86316522styes
tabes76033922tab_es
tables84524892tables
tyes76433372_tyes
wyes105727502_wyes
yes66250612__yes

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 Limit538001241.54634799.5
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.88994595.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.