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

123 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
binocles123641(None) 
binocle1136491binocle_
pinocles1248691pinocles
bicycles1743882bicycles
bindles104016452bin_dles
binnacles13244582binnacles
binocs1039922binoc__s
monocles12310672monocles
pinochles1644862pinochles
pinocle1138142pinocle_
pinoles93418712pino_les
anoles64827433_ano_les
bangles103617413ban_gles
barnacles1355333barnacles
benches143918603ben_ches
benzoles1936993benzoles
bernicles1345403bernicles
bibles104617643bi__bles
bices95029963bi__c_es
bicornes12307253bicornes
bicycle1643993bicycle_
bicycled1843133bicycled
bicycler1742693bicycler
bicyclers1842233bicyclers
biennales1143803biennales
bifaces1448063bifac_es
bifocaled1742463bifocaled
bifocals1543703bifocals
bigoses1039073bigo_ses
biles75542143bi___les
binaries10314183binaries
bindle94516263bin_dle_
bines76946793bin___es
binges93923123bin__ges
bingoes104013983bin_goes
binnacle12325633binnacle_
binocular1394613binocular
binoculars1463173binoculars
binuclear1382003binuclear
biocides1336943bi_ocides
bioclean1243153bi_oclean
biocycles1843523biocycles
biomes103815253bi_o_mes
bionomies1397153bionomies
birches143412323bi_rches
birles84920643bi__rles
bitches144117063bi_tches
bizones1837823bizo_nes
bocces123912023b__occes
boches134618523b__oches
bogles95020833b__ogles
boles75448603b__o_les
boodles103416043b_oodles
boucles113113003b_oucles
boules84925973b__oules
bricoles122610303brico_les
brindles113710233brin_dles
brioches15227253brioches
brooches15288193brooches
bunches144116033bun_ches
bundles103515773bun_dles
bungles104116763bun_gles
cenacles1238023cenacles
ciboules1244533ciboules
cinches144215773cin_ches
cineoles10109403cineoles
circles1139903ci_rcles
citoles9312553cito_les
dindles93817243din_dles
dingles93818323din_gles
dipoles101013753dipo_les
ennobles1045113ennobles
finagles12237553finagles
finales104016013fin_ales
finches153914193fin_ches
funicles13246833funicles
girolles935523girolles
icicles1135943_icicles
inches114419673_in_ches
incomes11712373_incomes
indoles83716363_indoles
ingles74420873_in_gles
inhales10511863_inhales
inkles103515653_in_kles
insoles73516243_insoles
jingles153816383jin_gles
kindles123614843kin_dles
linocuts1094573linocuts
manacles1239523manacles
minces104420803min_c_es
mingles103719003min_gles
miracles1238333miracles
monocle1139663monocle_
monocled1337113monocled
nobles83319723__nobles
nuncles939843nun_cles
oinomels1044513oinomels
panicles121010123panicles
panoches1548123panoches
penoches1538933penoches
pinches144117933pin_ches
pinholes131810663pinholes
pinnacles13276043pinnacles
pinnules1036473pinnules
pinochle1544753pinochle_
pinole83218783pino_le_
pinones94717073pino_nes
pintles94118733pin_tles
pinwales1367963pinwales
sanicles10149943sanicles
silicles1037073silicles
singles83520433sin_gles
socles8418453__socles
tingles83818323tin_gles
tinkles113713923tin_kles
tunicles10217133tunicles
uncles8317163_un_cles
winces114819113win_c_es
winches154714373win_ches
windles113518493win_dles
winkles143412773win_kles
winoes94317013wino__es
wintles103414983win_tles

Search took 9 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.656272394.8
2DLD Change Limit1461621237.81318707.5
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.51520985.4
 
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.