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

196 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
bombax193575(None) 
bombyx2232691bombyx
bomb106927422bomb__
bombard1437332bombard
bombast1348222bombast
bombe115519312bomb_e
bombed134113872bombed
bomber125014652bomber
bombes124916822bombes
bombs115818822bomb_s
boombox2073612boombox
borax145918722bo_rax
combat12316752combat
tombac12258882tombac
tombak14237752tombak
tombal102311022tombal
wombat1339862wombat
aboma91114603abom_a_
abomas101113583abom_as
baba88828353b_aba_
babas96325733b_abas
bamboo12310013bamboo
banjax2234763banjax
baobab946403baobab
barbal104016663barbal
bema85825253bem_a_
bemas96424283bem_as
bemean10410683bemean
bemix165011453bem_ix
bemoan10310253bemoan
bima86723833bim_a_
bimah127013273bim_ah
bimas95521743bim_as
bimbo114811873bimb_o
bimbos124610523bimbos
boa56954033bo__a_
boar66134293bo__ar
boas66150833bo__as
boat66360313bo__at
bob76755673bo_b__
bobbed104315833bobbed
bobber95016743bobber
bobbin93410733bobbin
bobble94115143bobble
bobby114814663bo_bby
bobcat12411253bobcat
bobs86340653bo_b_s
bogan87519003bo_gan
bogbean1244643bogbean
bohea105013733bohea_
boheas114013213boheas
bola66035563bo_la_
bolar75123473bo_lar
bolas74733763bo_las
bollix1538053bollix
bollox1548743bollox
bombable1336263bombable
bombards1536493bombards
bombasts1444953bombasts
bombers134512593bombers
bombing143211393bombing
bomblet13412263bomblet
bombload1543143bombload
bombyxes2442603bombyxes
bonbon10310073bonbon
bonsai838463bonsai
boob85932583boob__
boobed114514873boobed
boobie104015293boobie
booboo1039463booboo
boobs96221993boob_s
booby125319513boob_y
bora66141633bo_ra_
boral75831703bo_ral
boras75938303bo_ras
boreal84817213boreal
boreas85421733boreas
bota66236503bo_ta_
botas75328783bo_tas
boubou1038433boubou
bowman13129853bowman
box1210142343bo___x
boxball18155323boxball
boxcar1734753boxcar
boyar106013763bo_yar
boyla102912363boyla_
boylas113011723boylas
broadax1744453broadax
bromal10313653brom_al
bubal94218213b_ubal
bubba84311803bubba_
bubbas94110703bubbas
bulbar1039583bulbar
bumble124216893bumble
bumboat1349023bumboat
busbar1038453busbar
cabomba1544083cabomba_
cabombas1643813cabombas
coax136922983co__ax
coma87134853com_a_
comae97128423com_ae
comal95125133com_al
comas95833003com_as
comb106632113comb__
combats13311683combats
combe116223543comb_e
combed135516543combed
comber125118503comber
combes125321733combes
combo114519433comb_o
combos125316613combos
combs116122963comb_s
comix163513203com_ix
comma114514793comma_
commas124814573commas
commix19407763commix
compas125817063compas
corban10314693corban
cymbal15236913cymbal
domal85619203dom_al
embar94011603_embar
embay123410603_embay
forbad122710503forbad
gamba106018513gamba_
gambas115817513gambas
gimbal11228813gimbal
goban84414073go_ban
gombo105814043gomb_o
gombos114311093gombos
goombah1543113goombah
goombay1543553goombay
hoax147718293ho__ax
hombre13309303hombre
hotbox1835703hotbox
jumbal1758463jumbal
kombu1347243komb_u
kombus1435523kombus
limba95414983limba_
limbas105313203limbas
lobar7313013lo_bar
lumbar103610593lumbar
mamba116317523mamba_
mambas125716243mambas
max129045453__m_ax
mimbar1297493mimbar
momma85111053momma_
mommas94110653mommas
noma67529463nom_a_
nomad86016183nom_ad
nomas74726413nom_as
nontax1348413nontax
numbat10312083numbat
oba57531553_o_ba_
obas65730933_o_bas
omber95316443_omber
ombre94111803_ombre
oomiac1037063oomiac
oomiak1235353oomiak
oompah1334253oompah
poleax1547993poleax
roman75424823rom_an
rumba93612513rumba_
rumbas102512013rumbas
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
soba64927923so_ba_
sobas74424253so_bas
soma65635293som_a_
soman75024903som_an
somas76030373som_as
somber103714003somber
sombre10729473sombre
tambac122210243tambac
tambak14249263tambak
timbal102510753timbal
toman75724053tom_an
tomb89029653tomb__
tomback17227743tomback
tombacs13248443tombacs
tombaks15246863tombaks
tombed113812133tombed
tomboy1358213tomboy
tombs97818733tomb_s
tomcat101013453tomcat
tymbal13236823tymbal
woman105818003wom_an
womb117022233womb__
wombats1435893wombats
wombed14419233wombed
wombs125813343womb_s
womby155910093womb_y
zombi1838993zomb_i
zombie1937323zombie
zombis1936283zombis

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161964.84323274.0
3Display Results1961960.0464260.9
 (SQL Overall)1786911965.27933849.4
 
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.