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

120 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
mandible133754(None) 
mandibles1445541mandibles
addible11236062_addible
audible10228242_audible
manciple1445092manciple
manille92613272man_ille
maniple11249652man_iple
mendable131510582mendable
rendible11128352rendible
sandable111612822sandable
tangible1145602tangible
vendible14156472vendible
addable11218843_addable
aedile73716653_aedi_le
alible8311973_a_lible
amandine1148553amandi_ne
amendable1446053amendable
anile54634463_an_i_le
audibled12224093_audibled
audibles11215533_audibles
audibly13216043_audibly
audile73315303_audi_le
bankable1677913bankable
bannable1278353bannable
bendable131510853bendable
bindable13169623bindable
bondable13169273bondable
canaille1048413canaille
candidly1545213candidly
candle94321483cand__le
canticle1239703canticle
credible1346023credible
dandily12279633dandi_ly
dandle84218093dand__le
demandable1644343demandable
edible969353__edible
elidible1164573elidible
emendable1446233emendable
erodible1145493erodible
evadible1443973evadible
fadable13310463fa_dable
fallible1355363fallible
fencible1545603fencible
findable14179023findable
frangible1543753frangible
fungible1444173fungible
handbill14115163handbill
handily143610873handi_ly
handle104219293hand__le
hangable1438213hangable
inaudible1244633inaudible
inedible1147473inedible
lapsible1273973lapsible
laudable1137893laudable
lendable11169463lendable
mailable1239623mailable
maile75232223ma__i_le
makable15510203ma_kable
makeable1637253makeable
manacle11310283man_acle
manciples1564793manciples
mandala10310213mand_ala
mandate10315573mand_ate
mandibular1552243mandibular
mandibulate1652843mandibulate
mandioca1354113mandioca
mandola1039023mand_ola
mandrake1546003mandrake
mandrel1038683mandrel_
mandrels1137313mandrels
mandril1049353mandril_
mandrill1146613mandrill
mandrills1245453mandrills
mandrils1138493mandrils
mangily1339753mangi_ly
mangle93921323man__gle
manhole12311343man_hole
manila84518303man_i_la
manilla93012473man_illa
manilles102312603man_illes
maniples12269423man_iples
manlike133012783manli_ke
manlily1238743manli_ly
mannite9312903manni_te
mantilla1048163mantilla
mantle84420923man__tle
manwise1239183manwi_se
mappable1635923mappable
marble104219103ma__rble
maskable1638003maskable
minable112315073min_able
mineable121611053mineable
miscible1447673miscible
mixible18195093m_ixible
moldable1337103moldable
nonedible1245543nonedible
panicle11129983pan_icle
pantile93918483panti_le
partible1238063partible
passible1237693passible
radiable11611303ra_diable
radiale83813523ra_diale
radicle103510713ra_dicle
rinsible1046293rinsible
sandpile1146773sandpile
sanicle91210263san_icle
sendable111612043sendable
sensible1037853sensible
tangibles1243953tangibles
tangibly1444673tangibly
tannable1039383tannable
tensible1037243tensible
unedible1146413unedible
vendable14159693vendable
vendibles15164583vendibles
vendibly17174473vendibly
vincible1544753vincible
wadable13310233wa_dable
wandle105316663wand__le
windable14159153windable

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621207.32619951.1
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.77822973.9
 
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.