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

167 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
gambrel123545(None) 
gambrels1334211gambrels
gambe106219212gamb_e_
gambes116318312gamb_es
gambier124711972gambier
gamble115417182gamble_
gambled134112162gambled
gambler123612682gambler
gambles124016202gambles
gambol1138222gamb_ol
gangrel996142gangrel
gomerel1036392gomerel
timbrel11306562timbrel
tumbrel11406852tumbrel
ambeer104511603_ambeer
amber94523213_amb_er
ambers104519583_ambers
ambery133811133_ambery
amble95924643_amble_
ambled115116373_ambled
ambler104916453_ambler
ambles105121863_ambles
ambries111614553_ambries
ambry123512103_ambr_y
amoral8314633_amoral
babel95821693ba_b_el
barbel104317073barb_el
barrel84517873ba_rrel
camber124418483camb_er
cambered15129003cambered
cambers134017443cambers
cambial134010763cambial
cambric1537393cambric
camel96822803cam__el
cameral11311283cameral
carrel84718633ca_rrel
damosel10126703damosel
damozel19184353damozel
damsel9148033dam_sel
gabbed125216893ga_bbed
gabber114916603ga_bber
gabbers124612833gabbers
gabbier12379633gabbier
gabble113815723gabble_
gabbled134112453gabbled
gabbler124013303gabbler
gabbles124415413gabbles
gabbro11114953gabbr_o
gabbros12124653gabbros
gabies93820733ga_bies
gable85325523ga_ble_
gabled105518453ga_bled
gables94222333ga_bles
galere73716683galere_
galeres83514343galeres
galore73514873galore_
galores82614343galores
gamb96331843gamb___
gamba106018513gamb__a
gambade1336383gambade
gambades1435863gambades
gambado1344973gambado
gambas115817513gamb_as
gambia115912253gamb_ia
gambias125010733gambias
gambiers13337073gambiers
gambir11509773gamb_ir
gambirs12359083gambirs
gambit114714213gamb_it
gambits12399723gambits
gamblers13369733gamblers
gamboge1335583gamboge
gamboges1435653gamboges
gamboled1435873gamboled
gambols1238593gambols
gambs105721123gamb__s
game76644323gam__e_
gamed95126393gam__ed
gamely124711913gam__ely
gamer84928943gam__er
gamers94420833gamer_s
games86238553gam__es
gametal1037603gametal
gamete9313593gamete_
gametes10312253gametes
gamey115320553gam__ey
gamier93617933gam_ier
gamine94620153gamine_
gamines103618463gamines
gammed124216163gam_med
gammer1112318333gam_mer
gammers123214563gammers
gammier123711193gammier
gangrels1094973gangrels
garbed104815663garb_ed
garble94118453garble_
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
garboil1036513garboil
garred85217413ga_rred
garret74426563ga_rret
gastral8329553gastral
gastrea847243gastrea
gavel95815183ga__vel
gimbal11228813gimb_al
gimel8313353gim__el
gombeen1243733gombeen
gomeral1038843gomeral
gomerels1144573gomerels
gomeril1047383gomeril
gumball1266833gumball
gumboil1244373gumboil
gumtree1045873gumtree
haverel13397153haverel
hombre13309303hombre_
hombres14369883hombres
jambe165314753jamb_e_
jambed184811403jamb_ed
jambes175914053jamb_es
jamboree1944863jamboree
label75019383la_b_el
labret8320223la_bret
lambed115614783lamb_ed
lamber104418493lamb_er
lambers113817113lambers
lambert113617113lambert
lambie103213673lambie_
lambier113611643lambier
lambies113015113lambies
lamprey1434863lamprey
langrel8107033langrel
laurel649033la_urel
mamboed14417623mamboed
mamboes135011823mamboes
mandrel1038683mandrel
morel75729093__morel
nombril1145103nombril
ombre94111803_ombre_
ombres103911143_ombres
parrel84515983pa_rrel
ramble104519973ramble_
rambled123913523rambled
rambler113313263rambler
rambles113118313rambles
sabre74821503sa_bre_
sabred95916533sa_bred
sabres85520863sa_bres
sambaed1238303sambaed
sambal105215183samb_al
samiel8313333sam_iel
saurel6511993sa_urel
sombre10729473sombre_
sombrely1543703sombrely
timbral11237193timbral
timbre10328633timbre_
timbrels12265343timbrels
timbres11249353timbres
tumbrels12285733tumbrels
tumbril11256403tumbril
umbel93612843_umb_el
umbral1038633_umbral
wamble134415753wamble_
wambled153610753wambled
wambles143714023wambles
wastrel1037553wastrel
whimbrel1842433whimbrel

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.406440125.6
2DLD Change Limit1340271676.26321399.8
3Display Results1671670.0632650.8
 (SQL Overall)1786911676.73226543.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.