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

274 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
gimbal1122880(None) 
gimbals12257811gimbals
gimmal11247511gimmal
timbal102510741timbal
cymbal15236912cymbal
gamba106018512gamba_
gambas115817512gambas
gambol1138222gambol
gimbaled14104172gimbaled
gimel8313352gim_el
gimmals12225822gimmals
gingal81010142gingal
global937662global
gumball1266832gumball
imbalm1246302_imbalm
jumbal1758462jumbal
limba95414972limba_
limbas105313192limbas
mimbar1297482mimbar
pibal95217322pi_bal
sambal105215182sambal
timbale11248792timbale
timbals11239522timbals
timbral11237182timbral
tombal102311022tombal
tymbal13236822tymbal
aimful1166703aimful
airbag956963airbag
animal85016253anim_al
atabal839743atabal
bal56662723___bal
barbal104016663barbal
biaxal1536093biaxal
bima86723823bim_a_
bimah127013263bim_ah
bimas95521743bim_as
bimbo114811863bimb_o
bimbos124610513bimbos
bimetal1138433bimetal
bimodal1245663bimodal
binal75323823bi_nal
bombax1935753bombax
bubal94218213_bubal
cabal95222153_cabal
cambial134010753cambial
cembali13156043cembali
cembalo13145533cembalo
cibol9512023ci_bol
cimbalom1642443cimbalom
citral81113883citral
comal95125133com_al
combat12316753combat
cymbals16236143cymbals
dial55935063di__al
diobol936883diobol
disbar938513disbar
dismal92412243dismal
distal73615763distal
domal85619203dom_al
embalm1236643_embalm
embar94011593_embar
embay123410593_embay
filial93013253filial
fimble133611743fimble
fimbrial1544183fimbrial
final83922033fi_nal
finial92814183finial
fiscal1139333fiscal
gal46055513g___al
gama77035513gam_a_
gamas85431353gam_as
gamay116419103gam_ay
gamb96331843gamb__
gambade1336383gambade
gambado1344973gambado
gambe106219213gamb_e
gambes116318313gambes
gambia115912233gambia
gambias125010723gambias
gambir11509753gambir
gambit114714193gambit
gamble115417183gamble
gambols1238593gambols
gambrel1235453gambrel
gambs105721123gamb_s
gametal1037603gametal
gamma106116103gamma_
gammas115714693gammas
gasbag1035413gasbag
gavial10310083gavial
gayal9312713g_ayal
geminal10109893geminal
gemma106311773gemma_
gemmae11507793gemmae
genial74917613genial
gerbil938343gerbil
gib66443523gi_b__
gibbed124512353gibbed
gibber114112863gibber
gibbet114113383gibbet
gibbon1135323gibbon
gibe75927773gi_b_e
gibed96215963gi_bed
giber85417703gi_ber
gibes84422523gi_bes
gibs75529263gi_b_s
giddap1143413giddap
giga66720943gi_ga_
gigas75415583gi_gas
gill56336183gi__ll
gimbaling15134443gimbaling
gimballed1542673gimballed
gimels938893gimels
gimlet93716663gimlet
gimme102411343gim_me
gimmes113010903gimmes
gimmie11298173gimmie
gimp96124043gim__p
gimped123911473gimped
gimps105915203gim_ps
gimpy135212233gim_py
gingall9117323gingall
gingals9109303gingals
girl56226553gi__rl
gleba83910243gleba_
glebae9407613glebae
glial66715433g_lial
goal55829303g__oal
goban84414073g_oban
gombo105814043gomb_o
gombos114311093gombos
gomeral1038833gomeral
goombah1543113goombah
goombay1543553goombay
gooral7310463gooral
goral65125753g_oral
graal64316503g_raal
gremial1039153gremial
gumballs1345313gumballs
gumbo104413583gumb_o
gumboil1244373gumboil
gumbos114610873gumbos
gumma105313103gumma_
gummas114810513gummas
gyral94412783g_yral
hamal104623103ham_al
hammal134512063hammal
hemal104419803hem_al
herbal112513493herbal
hiatal9310193hiatal
hiemal11339493hiemal
hymnal1434913hymnal
ideal65716393_ideal
ileal56118083_ileal
ilial55317833_ilial
imam81718323_im_am
imbalms1334543_imbalms
imbark14347843_imbark
imbed105013633_imbed
imbue939463_imbue
impala10256923_impala
impale102811653_impale
impel95711763_impel
isba61310873_isba_
isbas71010393_isbas
jingal1498583jingal
jumbals18106533jumbals
kibla1139833ki_bla
kitbag1334973kitbag
libel74116103li_bel
lienal63912783lienal
lima65734133lim_a_
liman75921603lim_an
limas75627633lim_as
limb85429373limb__
limbate1139203limbate
limbed114513173limbed
limber104316773limber
limbi96513793limb_i
limbic12528723limbic
limbo95614803limb_o
limbos104712133limbos
limbs96118933limb_s
limbus105710373limbus
limby125714063limb_y
liminal93810673liminal
limpa97014463limpa_
limpas105513083limpas
lineal65616023lineal
lumbar103610593lumbar
mamba116317513mamba_
mambas125716243mambas
mammal95112753mammal
meal65643173__meal
mimbars1397373mimbars
mimical1339233mimical
miskal123710263miskal
missal84314903missal
mitral81314323mitral
nidal65217103ni_dal
nimbi94910293nimb_i
nimble103412933nimble
nimbly13388763nimbly
nimbus10377273nimbus
nival84915773ni_val
numbat10312083numbat
ogival1035873ogi_val
pial65636703pi__al
pibals103813083pi_bals
pical95524373pi_cal
piebald1245503piebald
pima85428653pim_a_
pimas94725103pim_as
pinball1137933pinball
pineal84817683pineal
pinnal84814273pinnal
pipal95118353pi_pal
primal104014623prim_al
ramal74622243ram_al
rambla103510933rambla
rial45938093ri__al
ribald9209293ri_bald
rictal83113173rictal
ritual6310613ritual
rival85216503ri_val
riyal84413433ri_yal
rumba93612513rumba_
rumbas102512013rumbas
sabal75422483_sabal
samba95618773samba_
sambals115213483sambals
sambar103914163sambar
sambas104219263sambas
sial45938833si__al
sibyl1037113si_byl
signal73711483signal
sima64730783sim_a_
simar74920813sim_ar
simas75727553sim_as
simian8811153simian
simnel857023simnel
sisal54217733si_sal
symbol1336083symbol
tamal73522613tam_al
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
tibial849833tibial
tical76021493ti_cal
tidal64516443ti_dal
timbales12227843timbales
timber104012673timber
timbre10328623timbre
timbrel11306553timbrel
tincal83913353tincal
tineal66216153tineal
tombac12258883tombac
tombak14237753tombak
tribal8611133tribal
tubal75517203_tubal
tymbals14265723tymbals
umbel93612833_umbel
umbral1038623_umbral
verbal112513663verbal
vial76731093vi__al
viminal12288823viminal
vinal85725813vi_nal
vineal94814743vineal
viral86419593vi_ral
visual938803visual
vital84819673vi_tal
wimble133211913wimble
withal1238933withal
wombat1339863wombat

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.1401276364.3
2DLD Change Limit1127162745.58020200.0
3Display Results2742740.0932946.2
 (SQL Overall)1786912745.81330739.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.