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

154 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
bonducs123555(None) 
bonduc1136601bonduc_
bonders104120662bonders
bonds86126842bond__s
bonus75324322bon_u_s
conduce12139232conduce
conduces13129782conduces
conduct121411592conduct
conducts13118712conducts
fondues11399312fondues
fondus105210942fondu_s
bandas95120543band_as
banders104324563banders
bandies104124863bandies
bandits103814793bandits
bandogs1138363bandogs
bands85233423band__s
bendays13327513bendays
bendees103913863bendees
benders104021063benders
bends85628973bend__s
bendys12518383bend_ys
binders103920743binders
bindis94614583bind_is
bindles104016453bindles
binds86627473bind__s
binocs1039923bin_ocs
bionics114310873bion_ics
blondes104213163blond_es
blonds95213343blond__s
bodes84935103bo_d_es
bodice11711423bo_dice
bodices12710593bo_dices
bodies94524143bo_dies
bods76244713bo_d__s
bogus85616473bo_gu_s
bolds85825283bold__s
bolus79125543bo_lu_s
bonaci10310963bon_aci
bonacis11310323bonacis
bonbons1139333bonbons
bond75334363bond___
bondage1138253bondage
bondages1237893bondages
bonded104719953bond_ed
bonder95324783bond_er
bonding113318433bonding
bondings12369413bondings
bondless1148813bondless
bondman1238043bondman
bondmen1237893bondmen
boners84825433bon_ers
bones76446533bon__es
bongoes104314113bongoes
bongos95316653bon_gos
bongs87828423bon__gs
bonitas939453bonitas
bonitos939733bonitos
bonkers134015303bonkers
bonks116326463bon__ks
bonnes85621453bon_nes
bonnets94812803bonnets
bonnock1545203bonnock
bonnocks1644623bonnocks
bonobos1136393bonobos
bonuses94212953bonuses
bonzes175116103bon_zes
boodies103721443boodies
boodles103416043boodles
boojums1842653boojums
boondock1763723boondock
boondocks1863023boondocks
bordels103911973bordels
borders104317533borders
bordure1035783bordure
bordures1136173bordures
bosques18217973bosques
bosuns8439383bo_suns
boudins10311313boudins
bounders114314113bounders
bounds94415803bound__s
bouts75131313bo__uts
boxfuls19113603boxfuls
broncs101611153bron__cs
bundles103515773bundles
bunds85523543bund__s
bundts95010843bund_ts
bunkums1544053bunkums
codecs115112933co_decs
concurs11311473concurs
concuss1138063concuss
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333cond_os
conduced14136963conduced
conducer13127373conducer
conducers14136563conducers
conduit10713083conduit
conduits111210063conduits
conics103920593con_ics
coniums11311863coniums
consuls92412313consuls
conus76726533con_u_s
cundums1235183cundums
donuts7410583don_uts
ebonics1137193ebon_ics
endues73813903_endues
foldups1332733foldups
fondles113512613fondles
fonds95824823fond__s
fondu96013973fondu__
fondue104510493fondu_e
fondued12466363fondued
fundus10429173fundu_s
gweducs1441303gweducs
holdups1333593holdups
hondas10313353hond_as
hondles113614523hondles
honours10339373honours
induce93811533_induce
induces103611813_induces
induct93212743_induct
inducts10259573_inducts
indues73515263_indues
ionics84214483ion_ics
ioniums938303ioniums
modus85417203mo_du_s
mondes94322353mond_es
mondos95217333mond_os
nodus66315993no_du_s
nonsuch1244683nonsuch
onus45826813_on_u_s
ponders103618843ponders
ponds85323403pond__s
rondels82510053rondels
rondos74616733rond_os
rondure837313rondure
rondures937713rondures
roundups1143593roundups
sendups10115193sendups
sonders83820713sonders
sondes74922873sond_es
sonics84315633son_ics
syndics1335703syndics
tendus75111183tendu_s
tondos75115923tond_os
tongues879693tongues
tonics83617863ton_ics
tonus56324303ton_u_s
vendues11318623vendues
voduns1035053vo_duns
windups1334783windups
wonders113315993wonders

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 Limit1340271546.66020124.2
3Display Results1541540.0463347.8
 (SQL Overall)1786911547.14225019.7
 
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.