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

170 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
gambade133638(None) 
gambades1435861gambades
gambado1344971gambado
ambage11510602_ambage
aubade939222_aubade
gamba106018512gamba__
gambadoes1542832gambadoes
gambados1444152gambados
gambas115817512gamba_s
gambe106219212gamb__e
gamble115417182gamb_le
gambled134112162gambled
gamboge1335582gamboge
garbage1138052garbage
lambada1245642lambada
sambaed1238302sambaed
abase76023483_a_base
abate76627843_a_bate
abide86223713_a_bide
abode85518813_a_bode
abrade9313053_abrade
aggrade1035643aggrade
alcade91111513_alcade
amaze166016603_am_aze
ambages1269623_ambages
ambari103012173_ambari
ambary134010543_ambary
amble95924643_amb_le
ambled115116373_ambled
ambsace1355963_ambsace
amebae1049633_ameba_e
amide86128483_am_ide
arcade91013643_arcade
aubades1038753_aubades
bade75140883___bade
ballade104012563ballade
barbate11314543barbate
cabbage1446983cabbage
camisade1374823camisade
carbide126112493carbide
cascade12118603cascade
chamade15138453cham_ade
clambake1843893clambake
comade114415323com_ade
comrade12139213comrade
damage10410773dam_age
facade1238803fa_cade
forbade13259103forbade
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbed125216893gabbed_
gabble113815723ga_bble
gabbled134112453gabbled
gable85325523ga_b_le
gabled105518453ga_bled
galeae74717453galea_e
galeate83916783galeate
gallate83417123gallate
galopade1243953galopade
gama77035523gam_a__
gamas85431363gam_a_s
gamay116419113gam_a_y
gamays126310913gam_ays
gamb96331843gamb___
gambes116318313gamb_es
gambia115912253gamb_ia
gambias125010733gambias
gambier124711973gambier
gambir11509773gamb_ir
gambirs12359083gambirs
gambit114714213gamb_it
gambits12399723gambits
gambler123612683gambler
gambles124016203gambles
gamboges1435653gamboges
gambol1138223gamb_ol
gamboled1435873gamboled
gambols1238593gambols
gambrel1235453gambrel
gambs105721123gamb__s
game76644323gam___e
gamed95126393gam_ed_
gamete9313593gam_ete
gamine94620153gam_ine
gamma106116103gamma__
gammadia1443923gammadia
gammas115714693gamma_s
gammed124216163gammed_
garage8314513ga_rage
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
garbed104815663garbed_
garble94118453garb_le
garbled114512803garbled
gasbag1035413gasba_g
gasbags1135473gasbags
gavage1137193ga_vage
gemmae11507793gemma_e
gemmate12418383gemmate
gimbal11228813gimba_l
gimbaled14104173gimbaled
gimbals12257823gimbals
glade75121963g__lade
glebae9407613gleba_e
globate1057823globate
grade75126093g__rade
grenade938413grenade
gumball1266833gumball
hamada1239923ham_ada
hamate113319833ham_ate
hambone1439313hambone
hammada1545093hammada
jambe165314753jamb__e
jambed184811403jambed_
lambadas1354873lambadas
lambast11129893lambast
lambaste12145013lambaste
lambda1146113lamb_da
lambdas1246243lambdas
lambed115614783lambed_
lambie103213673lamb_ie
lamiae84817453lamia_e
lampad114510033lampad_
lampads12477623lampads
limbate1139213limbate
limeade1076123limeade
made75440243__m_ade
mamba116317523mamba__
mambas125716243mamba_s
mamboed14417623mamboed
mammae94613213mamma_e
mammate104411273mammate
manmade1237963manmade
namable11312343namable
parade94720643pa_rade
parbake1538353parbake
parkade1437583parkade
passade1039233passade
pomade113611333pom_ade
prebade12310283prebade
ramada9310183ram_ada
ramate83921683ram_ate
ramble104519973ramb_le
rambled123913523rambled
rampage1237453rampage
remade94316983rem_ade
rumbaed12287493rumbaed
saccade12107033saccade
samba95618773samba__
sambal105215183samba_l
sambals115213483sambals
sambar103914163samba_r
sambars115113843sambars
sambas104219263samba_s
sambuke1544203sambuke
tamable11312853tamable
tamale83717403tam_ale
tambac122210243tamba_c
tambacs13219363tambacs
tambak14249263tamba_k
tambaks15218153tambaks
tambala1138023tambala
timbale11248803timbale
tribade1037293tribade
unmade92911063unm_ade
vambrace1743983vambrace
wamble134415753wamb_le
wambled153610753wambled

Search took 7 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.423422437.4
2DLD Change Limit1340271705.90622693.4
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.38927968.5
 
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.