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

207 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
abet61054794(None) 
abed79734131abed
abets75621671abets
abut66834951abut
bet58376671_bet
ab410674762ab__
aba512850952ab_a
abaft10318062abaft
abas68642082abas
abate76627842abate
abba810522652abba
abbe87627192abbe
abbes96723522abbes
abbey125714932abbey
abbot9318452abbot
abeam9316532abeam
abele76323252abele
abject17137702abject
able66340532able
abled86926832abled
abler75624312abler
ables75935542ables
ablest84721832ablest
ably99725132ably
abo59045962ab_o
abort76133582abort
abos67734412abos
about75229082about
abri65522212abri
abs59356072ab_s
absent84016992absent
abuts75417072abuts
aby810238062ab_y
abye97921002abye
abyes105518532abyes
abys97221882abys
ace59656832ace_
aced79540882aced
aces67645092aces
aceta74017352aceta
act59557842a_ct
adept81219642adept
adit56443652adit
ae212590292a_e_
aft66849012a_ft
age47154332age_
aged67334252aged
agee56241492agee
agent65829642agent
ager55935842ager
ages55844592ages
aglet65534142aglet
ahed89536252ahed
ahem97225362ahem
airt45757782airt
ait38093902a_it
ajee115928232ajee
akee85936812akee
albeit8314342albeit
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
alert54740652alert
ales47067102ales
alit46155692alit
alt36467962a_lt
amber94523212amber
ambit94223712ambit
amen66733152amen
ament76036542ament
ane37866952ane_
anent54931842anent
anes45255932anes
anew76623132anew
ant37270792a_nt
ante46538902ante
ape57251182ape_
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
apt57352542a_pt
are37874572are_
area45843392area
ares45871022ares
arete56031352arete
armet76739452armet
art38679142a_rt
asea46327182asea
asset55932262asset
at212393402a__t
ate37059242ate_
ates45047922ates
att35454652a_tt
aunt46553652aunt
ave67748702ave_
aver75931882aver
avert86029492avert
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
aye67151762aye_
ayes76543512ayes
babe86835822babe_
babel95821692babel
babes95834112babes
baht96740012baht
bait66556002bait
barbet104427882barbet
bast66362412bast
bat510988952_bat
bate66552422bate
batt65053872batt
be47948942_be_
beat66168302_beat
bed67950622_bed
bee56262402_bee
beet66457542beet
beg65944132_beg
bel57148462_bel
belt65754032_belt
ben56554922_ben
bent67759912_bent
bes56557432_bes
best66355322_best
beta66234132_beta
beth96629232_beth
bets67051442_bets
bey86645422_bey
bit57070902_bit
blet66247672blet
bot59680402_bot
but55963022_but
caber95126832caber
cablet104429462cablet
cadet85339342cadet
caret75360562caret
debt77139022debt
deet57356582deet
diet57357532diet
duet56446262duet
ebbet93517292ebbet
et26964192__et
facet106038522facet
feet75352212feet
fet66471632_fet
fret75845042fret
get47467462_get
habit103027022habit
haet75659502haet
het67674312_het
ibex133813482ibex
jabot14321512jabot
jet106754822_jet
keet85347332keet
khet116328622khet
label75019382label
labret8320222labret
leet45957902leet
let36481472_let
mabe85733362mabe_
mabes96331532mabes
meet65350552meet
met56072432_met
nabe66029492nabe_
nabes75427092nabes
net36670292_net
obe56638642obe_
obes66036832obes
obey96521302obey
obit66837082obit
objet141213142objet
palet74650802palet
pet56477302_pet
poet65552902poet
rabat72832222rabat
rabbet103818652rabbet
ramet75743142ramet
ret35982832_ret
sabe66140572sabe_
sabed86526812sabed
saber75330242saber
sabes76437462sabes
sabot7931782sabot
set36681252_set
stet45947322stet
suet46754822suet
taber73825822taber
tabes76033922tabes
tablet84227642tablet
tacet75840022tacet
tet39274992_tet
tret46653532tret
valet84337872valet
vet65958522_vet
weet75254152weet
wet65966622_wet
whet105133782whet
yet66960692_yet
zibet16419732zibet

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 Filter178691298720.0762351197.4
2DLD Change Limit298722070.86034734.9
3Display Results2072070.0464500.0
 (SQL Overall)1786912070.982181966.4
 
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.