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

229 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
biltong103468(None) 
biltongs1133811biltongs
belong93411042bel_ong
belting104119132belting
bilging114212682bilging
bilking144413552bilking
billing103823852billing
billon83713822billon_
billons93013352billons
biting95321822bi_ting
bitting103717292bitting
bolting104416762bolting
hilting113316892hilting
jilting153211742jilting
kilting123213852kilting
lilting83515382lilting
milting103619122milting
silting83320482silting
tilting83417102tilting
wilting113515912wilting
ailing74331013ail_ing
airting83616303airting
along65419493_al_ong
bailing103723523bail_ing
baiting103918883baiting
balcony1435853balcony
balding114015063balding
baling94829693bal_ing
balking143717353balking
balling104424763balling
ballon84117493ballon_
ballons93916953ballons
banteng1046363banteng
barong96015823b_arong
basting104227203basting
bating95132253b_ating
baton75822423b_aton_
batons85519423b_atons
batting104422273batting
beating104326873beating
belling103825073belling
belon73924113bel_on_
belongs10408223bel_ongs
belons84119413bel_ons
beltings11369253beltings
belying133612443belying
besting104923923besting
beton76022063b_eton_
betons84919553b_etons
betony114211583b_etony
betting103921403betting
biasing103512453biasing
bibbing11299603bibbing
bicron103710773bicron_
bicrons113410473bicrons
bidding123613503bidding
biding104720793bi_ding
bielding12237473bielding
biffing163510013biffing
bigging122815883bigging
bighting15269453bighting
biking135018173bi_king
bilbo95513603bilbo__
bilboa10367843bilbo_a
bilboas11438723bilboas
bilboes114410233bilboes
bilbos105011193bilbo_s
bilious9310933bilious
billabong1441953billabong
billbug1242753billbug
billeting1236633billeting
billings113412633billings
billion92212163billion_
billions102211783billions
billow114111223billo_w
billowing1545873billowing
billows123611283billows
billowy15366903billowy
binding113819383binding
binging113619383binging
binning103615453binning
binturong12112073binturong
biog76122313bi__o_g
biont7727163bi__ont
biotin83215823biotin_
biotins93114453biotins
biotope1146623biotope
biotron937293biotron_
biotrons1037233biotrons
birding114014923birding
birdsong1272563birdsong
birling104317053birling
birring103713063birring
birthing14338433birthing
bison75716983bi_son_
bisons83914373bi_sons
bistort91216523bistort
bitten84715123bitten_
bittings11339293bittings
bittock1544433bittock
bizone1738603bi_zone
blitzing2035903blitzing
blog75723823b_l_o_g
blond85618373b_l_ond
bluing94914483b_luing
boating103721303boating
boiling103819673boil_ing
bolling103820883bolling
bolson8410683bolson_
bolsons969483bolsons
boltonia1045513boltonia
bong75633413b___ong
booting103821363booting
boston8513043boston_
bostons9312893bostons
bouton8311533bouton_
boutons9310783boutons
bruting102612993bruting
building1237503building
bulging113514213bulging
bulking143815123bulking
bulling104324793bulling
bunting103718833bunting
burton8311273burton_
burtons9310853burtons
busting104221793busting
butling103516813butling
butting103519283butting
button8310273button_
buttons9310333buttons
buttony1236173buttony
citing94220183ci_ting
dalton7311273dalton_
daltons8310403daltons
dieting93616833dieting
dilating102714903dilating
diluting10248983diluting
dinting93520553dinting
dittoing1036263dittoing
felting113515213felting
fileting1239303fileting
filing103823763fil_ing
filling113520803filling
filming133210353filming
fisting113818123fisting
fitting113516563fitting
fliting113514613fliting
flong95815683_fl_ong
gifting123810893gifting
gilding103813003gilding
gilling93520383gilling
girting93113333girting
gitting93215703gitting
halting114419073halting
hilding123713533hilding
hilling113821773hilling
hilloing12158293hilloing
hinting113919223hinting
histing113720373histing
histone10312843histone
hitting113017273hitting
intone61115423_intone
jelutong1642053jelutong
jolting153410913jolting
kalong1177703kal_ong
killing123118723killing
kilning12289023kilning
kiloton1196313kiloton_
kilotons1286303kilotons
kiltings13327083kiltings
kiting114117093ki_ting
kitling123313573kitling
kitting123214443kitting
klong105310403_kl_ong
lifting113313273lifting
linting83820983linting
listing84020593listing
long56933343__l_ong
malting103219083malting
melting103317753melting
melton8311553melton_
meltons9410923meltons
milding113615453milding
milking143712763milking
milling103223683milling
minting103020813minting
misting103623383misting
molting103517173molting
nilling83619563nilling
niton55418283ni_ton_
nitons64614903ni_tons
oblong935383obl_ong
oiling74925313oil_ing
oilstone847273oilstone
oolong738073ool_ong
pelting102917273pelting
piling95025593pil_ing
pilling103722563pilling
piloting1139693piloting
piston83515923piston_
pistons93016373pistons
piton76121583pi_ton_
pitons85319043pi_tons
pitting103618873pitting
quilting18218713quilting
rifting113515003rifting
riling74227973ril_ing
rilling84023623rilling
rioting82716393rioting
salting84120793salting
sifting113014593sifting
silking123715593silking
siloing83215493siloing
siting74126623si_ting
sitting83519633sitting
stilting93312393stilting
tiling73426553til_ing
tilling83522773tilling
tinting84620603tinting
titling83715793titling
tong56434353___tong
welting113615313welting
wilding123814293wilding
wiling103024293wil_ing
willing113821613willing
wisting113519743wisting
witing103522823wi_ting
witling113215813witling
witting113417063witting

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.1561145455.1
2DLD Change Limit1340272298.78015265.0
3Display Results2292290.0932462.4
 (SQL Overall)1786912299.02919790.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.