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

163 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
abbes9672352(None) 
abbas95918641abbas
abbe87627191abbe_
abbess10509771abbess
abbey125714931abbey
abbeys13538421abbeys
ables75935541ables
abyes105518531abyes
babes95834111babes
abas68642082a_bas
abase76023482abase
abases85720772abases
abates85825032abates
abba810522652abb_a
abbot9318452abbot
abbots1039282abbots
abed79734132a_bed
abeles84719392abeles
abet610547942a_bet
abets75621672abets
abides94719892abides
able66340532able_
abled86926832abled
abler75624312abler
ablest84721832ablest
abodes94417512abodes
abos67734412a_bos
aboves114512842aboves
abris75722602abris
abs59356072a_b_s
abuse77119562abuse
abuses85119102abuses
abuts75417072abuts
abye97921002abye_
abys97221882a_bys
abyss10669462abyss
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adobes94411532adobes
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agues64919052agues
aides65336612aides
akees96119242akees
albas75925392albas
albs68628572alb_s
ales47067102a_les
almes75126542almes
aloes54933672aloes
amber94523212amber
ambers104519582ambers
ambles105121862ambles
ambos95321252ambos
amies76837692amies
anes45255932a_nes
antes56334322antes
apes66047432a_pes
apres75426402apres
apses76823912apses
arbs66834732arb_s
ares45871022a_res
arles56735742arles
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
ayes76543512a_yes
babas96325732babas
babbles104416322babbles
babe86835822babe_
babel95821692babel
babels105216722babels
babies106123652babies
babus95620332babus
bakes117035372bakes
bales76250082bales
banes74945582banes
barbes104526232barbes
bares75457132bares
bases75644352bases
bates75846342bates
bees65453382_bees
bes56557432__bes
byes95230532_byes
cabbed135416262cabbed
cabbies133115162cabbies
cables104527552cables
cubes95028162cubes
dabbed124416142dabbed
dabber114816962dabber
dabbers123813212dabbers
dabbles124514772dabbles
daubes94913702daubes
ebbed104111002ebbed
ebbet93517292ebbet
ebbets10376832ebbets
ebbs82411992ebb_s
fabber134814112fabber
fabbest1438032fabbest
fables114921672fables
gabbed125216892gabbed
gabber114916602gabber
gabbers124612832gabbers
gabbles124415412gabbles
gabies93820732gabies
gables94222332gables
gambes116318312gambes
gibes84422522gibes
gybes115012722gybes
hebes105521672hebes
jabbed184213482jabbed
jabber173713642jabber
jabbers183610582jabbers
jambes175914052jambes
jibes145520322jibes
jubes145420742jubes
kibbes143811192kibbes
kibes115521122kibes
lobes75331002lobes
lubes74727992lubes
mabes96331532mabes
maybes1339242maybes
nabbed115113612nabbed
nabber104913542nabber
nabbers113710462nabbers
nabes75427092nabes
obes66036832_obes
oboes75717712oboes
pubes94423402pubes
rabbet103818652rabbet
rabbets11279422rabbets
rabbies113416052rabbies
rabbis102613162rabbis
rabbles113517972rabbles
rabies85226022rabies
rebbes10313532rebbes
ribes75530172ribes
robes75133302robes
rubes74928412rubes
sabbed114518082sabbed
sabes76437462sabes
sables85026692sables
sabres85520862sabres
tabbed114215362tabbed
tabbies112913502tabbies
tabbis102910862tabbis
tabes76033922tabes
tables84524892tables
tubes74826452tubes
vibes104719952vibes
wabbles144013992wabbles
yabber136111832yabber
yabbers14389352yabbers
yabbies14279642yabbies

Search took 4 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.470380193.6
2DLD Change Limit538001632.86018811.2
3Display Results1631630.0463543.5
 (SQL Overall)1786911633.37652929.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.