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

198 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
bambino133648(None) 
bambini1336581bambini
bambinos1443871bambinos
albino839932_albino
amino75425502_am_ino
ammino1069882_ammino
bamboo12310012bamb_oo
bamming144611812bamming
barbing123716992barbing
bombing143211392bombing
jambing19328532jambing
lambing123412412lambing
albinos937653_albinos
amain74922913_amain_
ambient11310093_ambient
ambit94223713_ambi_t
ambits103713413_ambits
ambling121411793_ambling
ambo88225143_amb__o
amboina1137963_amboina
amido85720983_am_ido
amigo86515473_am_igo
amin66042253_am_in_
amine75835383_am_ine
amins75534323_am_ins
ammine10314493_ammine
ammono1047373_ammono
amnio75218053_amni_o
amnion84812053_amnion
amorino9310253_amorino
amping114317573_amping
arsino64113513_arsino
baaing94916163ba_aing
babbitt1038033babbitt
babbling12228693babbling
babied114913513ba_bied
babier103515573ba_bier
babies106123653ba_bies
baboo94319503ba_b_oo
baboon103613913ba_boon
babying1537963babying
baching156017753baching
backing165523443backing
badging123712793badging
baffing164011603baffing
bagging123316983bagging
bagnio937523bagni_o
bailing103723523bailing
baiting103918883baiting
baking135626623ba_king
balding114015063balding
baling94829693ba_ling
balking143717353balking
balling104424763balling
bamboos1348753bamboos
banding114921413banding
bandito103710043bandito
banging114019863banging
baning95127833ba_ning
banking144621353banking
banning103818233banning
barbie105018353barbi_e
barbies114519593barbies
barding113822893barding
barfing134615093barfing
barging114018483barging
baring95135853ba_ring
barking144724183barking
barning104320353barning
barring104021593barring
barrio8312573barri_o
bashing135422583bashing
basin75026923ba_sin_
basing95427663ba_sing
basins85722763ba_sins
basion84315853ba_sion
basking144718613basking
basting104227203basting
bastion9312473bastion
bathing134816243bathing
bating95132253ba_ting
batting104422273batting
batwing13509813batwing
bawling133813863bawling
baying125222583ba_ying
beaming123618803beam_ing
bibbing11299613bibbing
bimbo114811873bimb__o
blabbing12266723blabbing
blaming123515693blam_ing
bobbin93410733bobbin_
bobbing113113193bobbing
bobbins103410343bobbins
bombings15266493bombings
boobing123613913boobing
brambling1635543brambling
bribing123111043bribing
bumbling15249763bumbling
bumkin14308083bumkin_
bumkins15318013bumkins
bumming143410783bumming
bumping143812493bumping
cabbing143613153cabbing
cabin94820943ca_bin_
cabins104418923ca_bins
cambia124913153cambi_a
cambial134010763cambial
cambism1538033cambism
cambist13312113cambist
cambium1537323cambium
camion103917193cam_ion
camping143118973camping
campion133011413campion
carbine112918643carbine
carbinol1245783carbinol
casino84317553ca_sino
cassino93512433cassino
combine133014723combine
combing143714733combing
dabbing133511233dabbing
damming133812743damming
damning114211633damning
damping133414003damping
daubing11358623daubing
domino92611493dom_ino
dumbing13319853dumbing
famine114318193fam_ine
faming124922973fam_ing
gabbing133512033gabbing
gabion93211033ga_bion
gambado1344973gambado
gambia115912253gambi_a
gambias125010733gambias
gambier124711973gambier
gambir11509773gambi_r
gambirs12359083gambirs
gambit114714213gambi_t
gambits12399723gambits
gambling14218963gambling
gamin84423003gam_in_
gamine94620153gam_ine
gaming104622043gam_ing
gamins94420053gam_ins
gamming133112623gamming
garbing113613273garbing
hambone1439313hambone
hamming153014093hamming
iambi95512223iambi__
iambic12468283iambi_c
iambics13425643iambics
imino74315233_im_ino
jabbing19319413jabbing
jamming19329793jamming
kamsin1238323kamsin_
kamsins1346963kamsins
ladino73615123la_dino
lambent113711303lambent
lambie103213673lambi_e
lambier113611643lambier
lambies113015113lambies
lambkin1545243lambkin_
lambkins1664983lambkins
lamina84920443lam_ina
laming94528363lam_ing
lamming123014583lamming
lamping123116003lamping
lampion11278303lampion
latino64120473la_tino
limbing123410423limbing
mambo115215743mamb__o
mamboing1535973mamboing
nabbing12299963nabbing
naming93917893nam_ing
numbing12269033numbing
panino8315683pa_nino
pembina1345223pembina
rabbin103112303rabbin_
rabbins112811343rabbins
rambling131810773rambling
ramming123115063ramming
ramping123316873ramping
rampion11298583rampion
sabbing123314743sabbing
sabin74924953sa_bin_
sabine84020393sa_bine
sabins85521983sa_bins
sambaing1337113sambaing
sambo95118013samb__o
symbion1464043symbion
tabbing123611913tabbing
tamein8313093tamein_
tameins9311423tameins
taming94023433tam_ing
tamping122815813tamping
tampion11298663tampion
tombing123310533tombing
vamping152810233vamping
wambling16198443wambling

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271987.75017293.8
3Display Results1981980.0762605.3
 (SQL Overall)1786911988.23221706.9
 
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.