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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
bacilli114639(None) 
bacillar1276532bacillar
bacillus1245152bacillus
barilla9310322barilla
lapilli945642lapilli
acidly125211793_acidly
acini75718983_aci_ni
aculei839793_aculei
aioli5318313_a_ioli
ancilla948603ancilla
axilla13289573_axilla
bacalao1146613bacalao
bacchii1644533bacchii
bacillary1673973bacillary
backfill1965063backfill_
backfills20104653backfills
backflip2143093backflip
backlit15911903backlit
backlog1635773backlog
backslid1746273backslid
bacula103112673bac_ula
baculum1345703baculum
bail65042803ba_i_l_
bailed94726653ba_iled
bailee84526013ba_ilee
bailer85425253ba_iler
bailey115015673ba_iley
bailie83818363ba_ilie
bailor83412603ba_ilor
bails75933523ba_i_ls
ball66043323ba__ll_
balls76236413ba__lls
bally105530103ba__lly
banally1249223banally
barillas10310193barillas
basally1237963basally
basil75122273basi_l_
basilar937303basilar
basilic1137493basilic
basils85717473basi_ls
bastille1048003bastille
bazillion2043273bazillion
biali73419073b__iali
bill67239943b__ill_
billie85019173b__illie
bills75632863b__ills
billy105525363b__illy
braciola1245273braciola
braciole1246973braciole
braille939713braille
brill74819953b_rill_
brillo84211003b_rillo
brills84916293b_rills
celli76717693__celli
chilli114312773_chilli
dactyli1343603dactyli
facial113615633facial_
facially1637643facially
facials123310743facials
facile112514883faci_le
facilely1644363facilely
faille93414743fa_ille
fusilli1044233fusilli
lacily11612763laci_ly
latilla737953latilla
maill74420793ma_ill_
maills84215283ma_ills
manilla93012473manilla
manille92613273manille
maxilla16248193maxilla
nacelle938153nacelle
nucelli944723nucelli
ocelli836843_ocelli
oxacillin1852593oxacillin
papilla11127913papilla
rachilla1345713rachilla
racial83419243racial_
racially1339623racially
racily11715173raci_ly
ramillie1045863ramillie
ravioli1055613ravioli
sacculi1145043sacculi
scilla8310943_scilla
tacitly1236223tacitly
taille63116923ta_ille
vanilla10238743vanilla
vanillic1344263vanillic
vanillin1145913vanillin
villi86517853__villi

Search took 10 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.393454684.5
2DLD Change Limit134027899.14014663.8
3Display Results89890.0302966.7
 (SQL Overall)178691899.56318685.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.