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 “bibles” with Change Limit: [1] [2]

(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
bibles10461764(None) 
bible95119421bible_
bibless11439171bibless
biles75542141bi_les
birles84920641birles
ables75935542_ables
aisles64721142aisles
ambles105121862ambles
babbles104416322babbles
babels105216722babels
babes95834112bab_es
babies106123652babies
bales76250082b_ales
baubles113611862baubles
belles85325992belles
bialies93618412bialies
bialis83617162bialis
bialys11387912bialys
biases84618432biases
bibbed104712342bibbed
bibber94613572bibber
bibbers103911352bibbers
bibbs84911582bib_bs
biblist11310832biblist
bibs84831002bib__s
bices95029962bi_ces
bides85536782bi_des
bields94110002bields
biflex1834952biflex
bikes117529472bi_kes
bikies124515162bikies
bilbies114712342bilbies
bilboes114410242bilboes
bilbos105011202bilbos
bile66147192bi_le_
bilges94915632bilges
bilks115117892bi_lks
billed94224902billed
biller84923482biller
billers94720832billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bi_lls
bimboes13498732bimboes
bindles104016452bindles
bines76946792bi_nes
binges93923122binges
biomes103815252biomes
birle75023632birle_
birled94416992birled
birler85715082birler
birlers93813002birlers
birls74023162birl_s
birses84717732birses
bises75435622bi_ses
bites75641172bi_tes
bizes165923662bi_zes
bizzes163910842bizzes
bobbles104514912bobbles
bogles95020832bogles
boles75448602b_oles
boules84925972boules
bribees11409282bribees
bribes105918532brib_es
bridles104114472bridles
bubales113513342bubales
bubbles104315962bubbles
bubkes144612622bubkes
buboes104513992buboes
bugles94822442bugles
bumbles134016842bumbles
burbles114916802burbles
butles84423912butles
cables104527552cables
cobles104622882cobles
dibbles124013332dibbles
edibles1048002edibles
fables114921672fables
fibres114312122fibres
files85441272fi_les
filles94224522filles
fimbles143510662fimbles
foibles1238852foibles
gables94222332gables
gibes84422522gib_es
giblet93418892giblet
giblets103210422giblets
idles66720122_idles
isles54220562_isles
jibes145520322jib_es
kibbes143811192kibbes
kibbles153510252kibbles
kibes115521122kib_es
kiblas1239322kiblas
libels85112692libels
lisles63416282lisles
miles74645072mi_les
milles84526562milles
nibbles114011692nibbles
nobles83319722nobles
piles74742612pi_les
ribes75530172rib_es
ribless93410342ribless
riblet84222442riblet
riblets93412552riblets
rifles94217712rifles
riles55343642ri_les
rilles64725502rilles
robles85321692robles
rubles83921702rubles
sables85026692sables
sidles74721152sidles
tables84524892tables
tiles55542102ti_les
titles63719922titles
umbles103817492umbles
vibes104719952vib_es
wiles85437872wi_les
wimbles143010852wimbles

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511202.54632423.8
3Display Results1201200.0333636.4
 (SQL Overall)1786911202.92261153.7
 
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.