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

256 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
glebae940761(None) 
gleba83910241gleba_
glebe85016441gleb_e
amebae1049632amebae
galeae74717452gale_ae
gleam86916732gle_am
glean65818202gle_an
glebes95512242glebes
glede75517832gle_de
glee55239062gle__e
global937662global
globate1057822globate
globe84917012glob_e
grebe85114942greb_e
plebe95014872pleb_e
agleam9158623agle_am
aglee65728493agle__e
alae45643753al__ae
alba68328333al_ba_
albas75925393al_bas
alee46652323ale__e
alegar739283alegar
algae65319623al_gae
alible8311973alible
alulae6312743alulae
ameba9312373ameba_
ameban1039093ameban
amebas10311453amebas
amoebae1145533amoebae
areae55229743are_ae
beebee10313063beebee
blae66134643bl__ae
bleak115915383ble_ak
blear75918683ble_ar
bleat75737003ble_at
bleb85425223bleb__
blebby1233743blebby
blebs96416153bleb_s
blende95413443blende
cellae84915933cellae
chelae113614603chelae
clean75420413cle_an
clear76219053cle_ar
cleat76335063cle_at
cleave114212513cleave
cleome1039083cleome
clepe94617383cle_pe
debag94212303_debag
debar85517863_debar
debase94014473_debase
debate94419193_debate
debye1138903_debye
elevate101110373elevate
eyebar1135323eyebar
feeble1138253feeble
flea75628493fle_a_
fleabag1342923fleabag
fleabane1343633fleabane
fleam106017283fle_am
fleas86423663fle_as
fleche14299303fleche
fledge11439293fledge
flee76238793fle__e
fleece11369903fleece
flense938903flense
florae94713883florae
gabble113815723gabble
gable85325523g_able
gae46457703g___ae
galea64722933gale_a_
galeas74618503gale_as
galeate83916783galeate
galena74911093galena_
galenas83310333galenas
galere73716673gale_re
galette84212693galette
gamba106018513gamba_
gambade1336383gambade
gambas115817513gambas
gambe106219213gamb_e
gamble115417183gamble
garbage1138053garbage
garble94118453garble
gasbag1035413gasbag
gear55934973g_e_ar
gee45359203g_e__e
geegaw1142853geegaw
geese64316003g_eese
gelable101710733gelable
gelate73421253gelate
gelcap1136213gelcap
gelee63626983g_elee
gemmae11507793gemmae
gene56237223g_e_ne
genie66124923g_enie
genre66016803g_enre
geode7412593g_eode
gerah9315303g_erah
geste65920693g_este
geta56627443g_eta_
getas65421483g_etas
ghee85726113ghe__e
gherao1036753gherao
gibe75927773g_ib_e
gimbal11228803gimbal
glabrate1146033glabrate
glace87420153gl_ace
glad65624013gl__ad
glade75121963gl_ade
glaire74411293glaire
glaive10357933glaive
glam76529343gl__am
glance94312313glance
glare65222953gl_are
glaze155418163gl_aze
gleamed11327933gleamed
gleamer10328513gleamer
gleams94812253gleams
gleamy12398113gleamy
gleaned9349423gleaned
gleaner8379773gleaner
gleans75014743gleans
gled65631143gle__d
gledes84915133gledes
gleds75417893gle_ds
gleed75320573gle_ed
gleeds84711623gleeds
gleek105315103gle_ek
gleeked13346333gleeked
gleeks11489673gleeks
gleeman1035363gleeman
gleemen1035723gleemen
glees65027593gle_es
gleet65532343gle_et
gleeted9379323gleeted
gleets75315053gleets
gleety10479193gleety
gleg66219803gle__g
glegly1134873glegly
glen56027203gle__n
glens66519853gle_ns
gley85724653gle__y
gleyed11478153gleyed
gleys96514853gle_ys
glia56423153gl_ia_
glial66715433gl_ial
glias64618493gl_ias
glib79421433glib__
glibber1235163glibber
glibly1236293glibly
glide74521593gl_ide
glime85620193gl_ime
gloam86015943gl_oam
gloat65427683gl_oat
glob76623393glob__
globated1265753globated
globby1434683globby
globed104811763globed
globes94314543globes
globin9309723globin
globose1035543globose
globs85616403glob_s
globule1034383globule
glossae8477283glossae
glove94516293gl_ove
gloze154815983gl_oze
glucan936183glucan
glue55628493gl__ue
glume85120463gl_ume
glute66020903gl_ute
glycan1234903glycan
goban84414073g_oban
gobble113512983gobble
grease75416233grease
great66034243gre_at
greave104611493greave
grebes93813613grebes
gree56641563gre__e
greige847203greige
grenade938413grenade
guttae73210583guttae
gybe105916243g_yb_e
hebe96424703_heb_e
ilea45931463ile_a_
ileac75814173ile_ac
ileal56118083ile_al
kebab134311993_kebab
kebar115113533_kebar
lea37660183_le_a_
lead56038853_le_ad
leaf76441033_le_af
leak86233713_le_ak
leal46043273_le_al
lean46345243_le_an
leap66032683_le_ap
lear47045953_le_ar
leas45954183_le_as
lease55230263_lease
leave84723723_leave
leben7314853_leben
ledge76519463_ledge
lee36068143_le__e
legal65715943_legal
legate72917453_legate
leke85527403_le_ke
leman75622603_leman
lense54523433_lense
leone55018823_leone
lethe85717303_lethe
leva77020713_leva_
levee84023813_levee
librae84310173_librae
lobar7313013_lobar
lobate82915243_lobate
lobe65535363_lob_e
lube64731563_lub_e
olea46532723ole_a_
oleate6318883oleate
oleine6313793oleine
paleae84820293pale_ae
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
please84315733please
pleat74734473ple_at
pleb86123813pleb__
plebes104313623plebes
plebs95814583pleb_s
pledge10469473pledge
pleiad947833pleiad
plena75816393plena_
pleurae945863pleurae
plexal1536833plexal
plicae10410953plicae
prebade12310283prebade
prebake1539093prebake
rebar75420193_rebar
rebate84424103_rebate
rebbe9313153_rebbe
sclerae937933sclerae
setae56026223_setae
sleave94714153sleave
sleaze152611863sleaze
sledge85011283sledge
sleeve93411593sleeve
stelae63716483stelae
telae54323293_telae
thebe107515433theb_e
thecae11299653thecae
treble8311663treble
tubae74716643_tubae
ulema7109713ulema_
ulemas888963ulemas
ulnae55214573ul_nae
venae85920983_venae
zoeae144412483zoe_ae

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162565.93618988.5
3Display Results2562560.0932752.7
 (SQL Overall)1786912566.16928966.0
 
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.