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

114 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
addible1123606(None) 
addable11218841addable
audible10228241audible
addle74318352add__le
adducible1542212adducible
aedile73716652aedi_le
alible8311972a_lible
audibled12224092audibled
audibles11215532audibles
audibly13216042audibly
audile73315302audi_le
edible969352_edible
mandible1337542mandible
abdicable1685023abdicable
able66340533a___ble
abubble1044523abubble
actable11313473actable
addedly1344293addedly
addict10711203addi_ct
addicted1345073addicted
addicts1176013addicts
adding93914963addi_ng
additive1345863additive
addled94112523add__led
addles84216603add__les
adduce1076453add_uce
adhibit1345343adhibit
admirable1445433admirable
admire949933admi_re
adobe84814713a_dob_e
adorable1138773adorable
advice12107883advi_ce
advisable1544573advisable
advise10139223advi_se
advisee11147153advisee
aediles83413903aedi_les
aedine73218393aedi_ne
affable15117403affable
agile65122263a_gi_le
aisle55223193a__isle
alliable1038433alliable
amble95924643a__mble
amiable11312033amiable
anile54634463a_ni_le
arable81821003a_rable
article9310923article
astilbe945653astilbe
audial7312993audial_
audiles83112613audi_les
auditable1245993auditable
auditee8311573auditee
auricle9139813auricle
awhile1257793awhi_le
axile126020513a_xi_le
baddie104114033baddi__e
beddable14166923beddable
bible95119423__bible
biddable14165673biddable
caddice13327733caddi_ce
caddie104316453caddi__e
codable12311663codable
credible1346023credible
dabble114515193_dabble
daddle94214283dad_dle
dariole8711163dariole
datable101714233datable
dibble114013843_dibble
diddle94915213_diddle
doable93115243_doable
double94013993_double
dribble12368603_dribble
driblet103712243_driblet
dyable12308983_dyable
edibles1048003_edibles
edile64819493_edi_le
educible1344433educible
elidible1164573elidible
erodible1145493erodible
evadible1443973evadible
fadable13310463fadable
fallible1355363fallible
foible11410383_foible
fusible1237023fusible
hidable1399403hidable
inaudible1244633inaudible
inedible1147473inedible
laddie83713173laddi__e
lapsible1273973lapsible
laudable1137893laudable
legible1035833legible
mandibles1445543mandibles
mixible18195093mixible
paddle104615143padd__le
partible1238063partible
passible1237693passible
pedicle1238973pedicle
raddle84816173radd__le
radiable11611303radiable
radiale83813523radiale
radicle103510713radicle
rendible11128353rendible
ridable101412493ridable
risible937923risible
saddle83915493sadd__le
sandable111612823sandable
sedile73517233sedi_le
tangible1145603tangible
unedible1146413unedible
vendible14156473vendible
visible1236923visible
wadable13310233wadable
waddie114013323waddi__e
waddle114715303wadd__le
wadeable1437443wadeable

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.1561145455.1
2DLD Change Limit1340271146.97019229.1
3Display Results1141140.0303800.0
 (SQL Overall)1786911147.15624970.8
 
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.