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 “gabelle” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
gabelle1025921(None) 
gabelled12317581gabelled
gabelles11278931gabelles
gazelle17236331gazelle
abele76323252_abe_le
belle75827832__belle
cadelle1039922cadelle
gabble113815722gab_ble
gable85325522gab__le
gavelled13387362gavelled
gazelles18266562gazelles
glabella1144272glabella
glabellae1243742glabellae
labella988942labella
labelled11278292labelled
labeller10248072labeller
nacelle938152nacelle
abeles84719393_abeles
abelia83114403_abelia
able66340533_ab__le
abolla8410193_abolla
abollae936943_abollae
allele64514563_allele
amarelle1045613amarelle
anele55628833_ane_le
areole61017283_areole
babble94017113bab_ble
babel95821693babe_l_
babels105216723babe_ls
bagatelle1252303bagatelle
barbell11429963barbell_
barbells12368823barbells
belie75630383__belie
bell66237183__bell_
belled94626183__belled
belles85325993__belles
bells76432163__bells
belly104625493__belly
caballed1337163caballed
cable95329913cab__le
cadelles1139973cadelles
canella9310793canella
dabble114515193dab_ble
echelle1246623echelle
fable105824753fab__le
faille93414743fa_ille
favella1336173favella
flabella1344963flabella
gabbled134112453gabbled
gabbler124013303gabbler
gabbles124415413gabbles
gabled105518453gab_led
gablelike1643663gablelike
gables94222333gab_les
gaggle93412623ga_ggle
gale56347323ga___le
galeae74717453gale_ae
galeate83916783galeate
galere73716673gale_re
galette84212693galette
galilee8312213galilee
gall56335993ga__ll_
galled84622863ga__lled
gallet73630853ga__llet
galley104215453ga__lley
galls64729323ga__lls
gally95026173ga__lly
gamble115417183ga_mble
gambolled1543103gambolled
gamelan10106643gamelan
gamelike1538033gamelike
gamely124711913game_ly
gamete9313593game_te
garble94118453ga_rble
gargle84215463ga_rgle
gaselier946963gaselier
gatelike1337933gatelike
gavel95815183gave_l_
gaveled12399133gaveled
gavels105911093gave_ls
gazette17357363gazette
gelee63626983g__elee
gelled84718893g__elled
gerbille1144613gerbille
girolle835793girolle
glabellar1243243glabellar
gobble113512983gob_ble
gorbelly1445473gorbelly
grabble12339643grab_ble
gravelled1475553gravelled
gravelly15385773gravelly
grille74315743g_rille
gruelled1034893gruelled
grueller935333grueller
habile11515213hab_ile
hazelly2254383hazelly
label75019383labe_l_
labelable1344393labelable
labeled102510563labeled
labeler92310183labeler
labellate11126923labellate
labellers11206553labellers
labellum1274273labellum
labels84515683labe_ls
labile8315223lab_ile
lamella988613lamella
lamellae10117033lamellae
lapelled11227083lapelled
libelee92510983libelee
libelled11317213libelled
libellee10227733libellee
libeller10297433libeller
manille92613273manille
micelle1178343micelle
mirabelle1343333mirabelle
morelle91210803morelle
nacelles1048393nacelles
novelle1058233novelle
organelle1043593organelle
paella8410913pa_ella
panelled1138963panelled
patella938953patella
patellae1047623patellae
rabble103818243rab_ble
ravelled12419783ravelled
raveller11339263raveller
ravelly13268353ravelly
rebelled113110323rebelled
roselle7310243roselle
rubella9146523rubella
sable74732163sab__le
selle54428313__selle
table75429603tab__le
taille63116923ta_ille
umbelled1336273umbelled
umbellet1247073umbellet
wabble133714843wab_ble

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271377.17318684.9
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.35924282.0
 
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.