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

121 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
binocle113649(None) 
binocles1236411binocles
pinocle1138141pinocle
bicycle1643992bicycle
bindle94516262bin_dle
binnacle12325632binnacle
binocs1039922binoc_s
monocle1139662monocle
pinochle1544752pinochle
pinocles1248692pinocles
pinole83218782pino_le
anole55330383_ano_le
bangle94018963ban_gle
barnacle1245943barnacle
benzole1837133benzole
bernicle1245443bernicle
bible95119423bi__ble
bice86235573bi__c_e
bicorne11297553bicorne
bicycled1843133bicycled
bicycler1742693bicycler
bicycles1743883bicycles
biennale1044103biennale
biface1358103bifac_e
bifocal1445373bifocal
bifocaled1742463bifocaled
bifocals1543703bifocals
bifold1237223bifo_ld
bile66147193bi___le
binal75323823bin_al_
binate8419773bin_ate
bindable13169623bindable
bindles104016453bin_dles
bine66650873bin___e
binge85125513bin__ge
binnacles13244583binnacles
binocular1394613binocular
binuclear1382003binuclear
biocide1237323bi_ocide
bioclean1243153bi_oclean
biocycle1743143biocycle
biome94916993bi_o_me
birle75023633bi__rle
bitable11312203bitable
bizone1738603bizo_ne
bocce114313113b__occe
boche124216953b__oche
bogle85821683b__ogle
bole66448693b__o_le
boodle93215033b_oodle
boucle103712783b_oucle
boule74828043b__oule
bricole112810493brico_le
brindle104210103brin_dle
brioche14275923brioche
broche133612103b_roche
bundle94315573bun_dle
bungle97116113bun_gle
cenacle1139123cenacle
ciboule1145093ciboule
cineole91010003cineole
circle1039703ci_rcle
citole8311503cito_le
dindle84417223din_dle
dingle84317073din_gle
dipole91112853dipo_le
ennoble935633ennoble
finable122213623finable
finagle11238313finagle
finale94116763fin_ale
funicle12237483funicle
girolle835793girolle
icicle1036583_icicle
ignoble1043613ignoble
income10712093_income
indocile1146703_indocile
indole74516053_indole
ingle64120433_in_gle
inhale9411523_inhale
inkle94515833_in_kle
inocula947273_inocula
insole63515863_insole
jingle143815223jin_gle
kindle114414243kin_dle
linable92214343linable
linocut997673linocut
manacle11310283manacle
minable112315073minable
mince95325233min_c_e
mingle93518783min_gle
miracle1138843miracle
monocled1337113monocled
monocles12310673monocles
noble74420993__noble
nuncle839363nun_cle
oinomel946353oinomel
panicle11129983panicle
panoche1456383panoche
penoche1447043penoche
pinhole122010433pinhole
pinnacle12416963pinnacle
pinnule936003pinnule
pinochles1644863pinochles
pinoles93418713pino_les
pintle83818263pin_tle
pinwale1257843pinwale
sanicle91210263sanicle
silicle937753silicle
since75024173sin_c_e
single74520603sin_gle
sinopie948783sinopie
socle7419573__socle
tingle74319073tin_gle
tinkle103714453tin_kle
tunicle9308033tunicle
uncle7317053_un_cle
wince105220883win_c_e
windle104617953win_dle
winkle133812833win_kle
wintle94014603win_tle
yince105214253yin_c_e

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.436409841.7
2DLD Change Limit1340271216.70319995.1
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.18524870.0
 
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.