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

130 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
gamboled143587(None) 
gambled134112161gamb_led
gambolled1543101gambolled
ambled115116372_amb_led
gabbled134112452ga_bbled
gabled105518452ga_b_led
gamble115417182gamb_le_
gambler123612682gamb_ler
gambles124016202gamb_les
gamboge1335582gamboge_
gamboges1435652gamboges
gambol1138222gambol__
gambols1238592gambol_s
gammoned1444992gammoned
gaoled84814502ga__oled
garbled114512802garb_led
gimbaled14104172gimbaled
hamboned1637002hamboned
mamboed14417622mambo_ed
rambled123913522ramb_led
symboled1644492symboled
wambled153610752wamb_led
abled86926833_a_b_led
aboded104912513_a_boded
amble95924643_amb_le_
ambler104916453_amb_ler
ambles105121863_amb_les
ambones11312683_ambones
amole75724593_am_ole_
amoles84122193_am_oles
arbored103811603_arbored
babbled113612863ba_bbled
bamboozled2651353bamboozled
brambled15316733bramb_led
bumbled144113043bumb_led
cabled114819873ca_b_led
cajoled17428283ca_joled
camailed1336553camailed
cambered15129003cambered
cameoed1238383cameo_ed
carboyed1637183carboyed
caroled103717693ca_roled
dabbled133712073da_bbled
embowed15236903_embowed
fabled124216383fa_b_led
fumbled153710493fumb_led
gabbed125216893ga_b_bed
gabble113815723ga_bble_
gabbler124013303ga_bbler
gabbles124415413ga_bbles
gabelled12317583gabelled
gable85325523ga_b_le_
gables94222333ga_b_les
gaggled11359913ga_ggled
galled84622863ga__lled
galloped12107143galloped
galoped11138073ga_loped
gambade1336383gambade_
gambades1435863gambades
gambe106219213gamb__e_
gambes116318313gamb__es
gambier124711973gamb_ier
gamblers13369733gamb_lers
gamboling1556133gamboling
gambrel1235453gamb_rel
gambrels1334213gambrels
gamed95126393gam___ed
gammed124216163gam__med
gammoner1345153gammoner
gaoler73913573ga__oler
garbed104815663garb__ed
garble94118453garb_le_
garbler104012563garb_ler
garbles104016923garb_les
garboard1247243garboard
gargled104210673ga_rgled
gargoyled1541993gargoyled
garoted9710133ga_roted
garroted1056783garroted
gaveled12399133ga_veled
gavelled13387363gavelled
gimballed1542673gimballed
gobbled134010253g_obbled
grabbled14327373grabbled
grumbled14256753grumb_led
hambone1439313hambone_
hambones1539673hambones
harbored1438633harbored
humbled153711813humb_led
jambed184811403jamb__ed
jamboree1944863jamboree
jawboned21133553jawboned
jumbled19379963jumb_led
labeled102510563la_beled
labored102810243la_bored
lambed115614783lamb__ed
mamboes135011823mambo_es
marbled123212113marb_led
mobled113213183__mobled
mumbled143010763mumb_led
parboiled1445223parboiled
paroled104217633pa_roled
rabbled123514423ra_bbled
ramble104519973ramb_le_
rambler113313263ramb_ler
rambles113118313ramb_les
rampole1139693rampole_
rampoles1238893rampoles
rawboned14114253rawboned
rumbled124514593rumb_led
sambaed1238303samb_aed
samoyed1335893sam_oyed
sampled123410793sam_pled
shambled16156153shamb_led
sjamboked2541723sjamboked
symbolled1742823symbolled
tabled94020043ta_b_led
tabooed10267383ta_booed
tabored102810563ta_bored
tamboured1443783tamboured
tamponed1336023tamponed
tumbled123412243tumb_led
umbeled12208193_umbeled
vamoosed1443923vamoosed
vamosed1335923vam_osed
wabbled153311443wa_bbled
wamble134415753wamb_le_
wambles143714023wamb_les
warbled133212163warb_led
wimbled15298153wimb_led

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621306.71621763.3
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.18524870.0
 
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.