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
gimbal1122881(None) 
gimbals12257821gimbals
gimmal11247511gimmal
timbal102510751timbal
cymbal15236912cymbal
gamba106018512gamba_
gambas115817512gambas
gambol1138222gambol
gimbaled14104172gimbaled
gimel8313352gim_el
gimmals12225822gimmals
gingal81010152gingal
global937662global
gumball1266832gumball
imbalm1246322_imbalm
jumbal1758462jumbal
limba95414982limba_
limbas105313202limbas
mimbar1297492mimbar
pibal95217322pi_bal
sambal105215182sambal
timbale11248802timbale
timbals11239532timbals
timbral11237192timbral
tombal102311022tombal
tymbal13236822tymbal
aimful1166703aimful
airbag956963airbag
animal85016253anim_al
atabal839743atabal
bal56662723___bal
barbal104016663barbal
biaxal1536093biaxal
bima86723833bim_a_
bimah127013273bim_ah
bimas95521743bim_as
bimbo114811873bimb_o
bimbos124610523bimbos
bimetal1138433bimetal
bimodal1245663bimodal
binal75323823bi_nal
bombax1935753bombax
bubal94218213_bubal
cabal95222153_cabal
cambial134010763cambial
cembali13156043cembali
cembalo13145533cembalo
cibol9512023ci_bol
cimbalom1642443cimbalom
citral81113893citral
comal95125133com_al
combat12316753combat
cymbals16236143cymbals
dial55935063di__al
diobol936883diobol
disbar938513disbar
dismal92412243dismal
distal73615773distal
domal85619203dom_al
embalm1236653_embalm
embar94011603_embar
embay123410603_embay
filial93013253filial
fimble133611753fimble
fimbrial1544193fimbrial
final83922033fi_nal
finial92814183finial
fiscal1139333fiscal
gal46055513g___al
gama77035523gam_a_
gamas85431363gam_as
gamay116419113gam_ay
gamb96331843gamb__
gambade1336383gambade
gambado1344973gambado
gambe106219213gamb_e
gambes116318313gambes
gambia115912253gambia
gambias125010733gambias
gambir11509773gambir
gambit114714213gambit
gamble115417183gamble
gambols1238593gambols
gambrel1235453gambrel
gambs105721123gamb_s
gametal1037603gametal
gamma106116103gamma_
gammas115714693gammas
gasbag1035413gasbag
gavial10310083gavial
gayal9312713g_ayal
geminal10109913geminal
gemma106311773gemma_
gemmae11507793gemmae
genial74917613genial
gerbil938343gerbil
gib66443533gi_b__
gibbed124512353gibbed
gibber114112863gibber
gibbet114113383gibbet
gibbon1135323gibbon
gibe75927783gi_b_e
gibed96215963gi_bed
giber85417703gi_ber
gibes84422523gi_bes
gibs75529273gi_b_s
giddap1143413giddap
giga66720943gi_ga_
gigas75415583gi_gas
gill56336183gi__ll
gimbaling15134443gimbaling
gimballed1542673gimballed
gimels938893gimels
gimlet93716663gimlet
gimme102411343gim_me
gimmes113010903gimmes
gimmie11298183gimmie
gimp96124043gim__p
gimped123911473gimped
gimps105915203gim_ps
gimpy135212233gim_py
gingall9117333gingall
gingals9109313gingals
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
hamal104623113ham_al
hammal134512063hammal
hemal104419803hem_al
herbal112513493herbal
hiatal9310203hiatal
hiemal11339503hiemal
hymnal1434913hymnal
ideal65716393_ideal
ileal56118083_ileal
ilial55317843_ilial
imam81718333_im_am
imbalms1334553_imbalms
imbark14347863_imbark
imbed105013653_imbed
imbue939483_imbue
impala10256933_impala
impale102811663_impale
impel95711773_impel
isba61310883_isba_
isbas71010403_isbas
jingal1498593jingal
jumbals18106533jumbals
kibla1139833ki_bla
kitbag1334973kitbag
libel74116103li_bel
lienal63912783lienal
lima65734133lim_a_
liman75921603lim_an
limas75627633lim_as
limb85429383limb__
limbate1139213limbate
limbed114513183limbed
limber104316793limber
limbi96513813limb_i
limbic12528743limbic
limbo95614813limb_o
limbos104712143limbos
limbs96118943limb_s
limbus105710383limbus
limby125714073limb_y
liminal93810673liminal
limpa97014463limpa_
limpas105513083limpas
lineal65616023lineal
lumbar103610593lumbar
mamba116317523mamba_
mambas125716243mambas
mammal95112753mammal
meal65643173__meal
mimbars1397383mimbars
mimical1339233mimical
miskal123710263miskal
missal84314903missal
mitral81314323mitral
nidal65217103ni_dal
nimbi94910313nimb_i
nimble103412943nimble
nimbly13388773nimbly
nimbus10377283nimbus
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
rictal83113183rictal
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
rumba93612513rumba_
rumbas102512013rumbas
sabal75422483_sabal
samba95618773samba_
sambals115213483sambals
sambar103914163sambar
sambas104219263sambas
sial45938833si__al
sibyl1037113si_byl
signal73711483signal
sima64730783sim_a_
simar74920813sim_ar
simas75727553sim_as
simian8811163simian
simnel857023simnel
sisal54217733si_sal
symbol1336083symbol
tamal73522623tam_al
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
tibial849843tibial
tical76021493ti_cal
tidal64516443ti_dal
timbales12227843timbales
timber104012683timber
timbre10328633timbre
timbrel11306563timbrel
tincal83913363tincal
tineal66216163tineal
tombac12258883tombac
tombak14237753tombak
tribal8611133tribal
tubal75517203_tubal
tymbals14265723tymbals
umbel93612843_umbel
umbral1038633_umbral
verbal112513663verbal
vial76731093vi__al
viminal12288823viminal
vinal85725813vi_nal
vineal94814743vineal
viral86419593vi_ral
visual938803visual
vital84819673vi_tal
wimble133211923wimble
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.720248181.9
2DLD Change Limit1127162744.62324381.6
3Display Results2742740.0962854.2
 (SQL Overall)1786912745.43932853.6
 
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.