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

162 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
gliomas103533(None) 
glioma935951glioma_
glias64618492gli__as
glimes94717522gli_mes
glims87417672gli_m_s
gliomata1143542gliomata
gloams95210662gl_oams
gloms85219782gl_om_s
glomus9468092gl_omus
glooms96211682gloom_s
limas75627632_li_mas
lipomas1156442_lipomas
abomas101113583_abomas
alias55834603ali__as
aliyas93911803ali_yas
almas76629773al__mas
alohas9411703al_ohas
angiomas1145813angiomas
animas84418723ani_mas
aromas81018613_aromas
axioms15408053axiom_s
bimas95521743_bi_mas
biogas94310913_biogas
biomass1155993_biomass
biomes103815253_biomes
biotas84313923_biotas
blimps12588153bli_mps
blooms104613173bloom_s
caeomas1138403caeomas
chromas142512693chromas
cleomes1138813cleomes
climax1735653cli_max
climbs12498723cli_mbs
climes104720003cli_mes
clivias1266693clivias
clomps125212233cl_omps
comas95833003__comas
enigmas1045173enigmas
floras94715693fl_oras
flotas94013003fl_otas
galiots82311323galio_ts
gamas85431363g__amas
gammas115714693g_ammas
geishas1135073geishas
genoas74013623geno_as
genomes103611703genomes
genoms94412483genom_s
gigas75415583g_i_gas
gimmal11247513g_immal
gimmals12225823g_immals
gimmes113010903g_immes
gimps105915203g_i_mps
gismos957183g_ismos
gizmos1844133g_izmos
gladiolas1183473gladiolas
glamors1068113glamors
glams85822933gl_am_s
glaucomas1442243glaucomas
gleams94812253gleam_s
gleeman1035363gleeman
glia56423153gli__a_
glial66715433gli__al
gliders94811843gliders
glides84518863gli_des
gliffs13436323gli_ffs
glim76026353gli_m__
glime85620193gli_m_e
glimed105312283gli_med
glimmer12437713glimmer
glimmers13396153glimmers
glimpse1233763gli_mpse
glints75714213gli_nts
glitzes17367563glitzes
gloam86015943gl_o_am
gloat65427683gl_o_at
gloats74515423gl_oats
global937663gl_obal
globes94314543gl_obes
globs85616403gl_o_bs
gloggs935033gl_oggs
glom75424383gl_om__
gloom87116523gloom__
gloomed11337413gloomed
gloomy12528763gloom_y
glops85619553gl_o_ps
glorias81610323glorias
gloss64319623gl_o_ss
glossa7529163gl_ossa
glossas8438193glossas
glosts74513813gl_osts
glouts74414713gl_outs
gloves104115183gl_oves
glows95518033gl_o_ws
glozes164313353gl_ozes
glumes94516813gl_umes
glums84621423gl_um_s
gluons738503gluo_ns
gnomes93812973g_nomes
goas55239943g__o_as
gramas94317203g_ramas
grammas12499773grammas
grimes94619033gri_mes
gringas938043gringas
griots74713643grio_ts
gripman1234463gripman
grooms94512523groom_s
guineas836753guineas
gummas114810513g_ummas
gyozas1933613g_yozas
idioms956413idiom_s
iotas54821113__iotas
lamas75532793_l_amas
lemmas10349163_lemmas
lianas63713383_lianas
libras83711703_libras
lima65734133_li_ma_
liman75921603_li_man
limans84816303_li_mans
limbas105313203_limbas
limbs96118943_li_mbs
limes75636503_li_mes
limns75718393_li_mns
limos75320813_li_mos
limpas105513083_limpas
limps95522673_li_mps
lingas75116573_lingas
lions55923213_lio_ns
lipoma1046753_lipoma_
liras56021983_li_ras
litas54923773_li_tas
litmus836323_litmus
llamas888973_llamas
loams75619863_l_oams
loofas9429833_loofas
looms75124643_loom_s
lotas55926303_l_otas
loumas84812333_loumas
lumas75622913_l_umas
melismas1245713melismas
myomas1338303_myomas
myxomas2153913myxomas
nomas74726413__nomas
olios54520853olio__s
pimas94725103_pi_mas
plasmas113010753plasmas
polyomas1546993polyomas
primas104418103pri_mas
riojas1335813_riojas
scoliomas1342773scoliomas
sigmas94111363_sigmas
simas75727553_si_mas
slimes84722043sli_mes
slims75423653sli_m_s
somas76030373__somas
stigmas10206643stigmas
stomas84816323_stomas
tritomas1048033tritomas
ulamas8910453ul_amas
ulemas888963ul_emas
ultimas936363ultimas
violas93713523_violas
zygomas2243413zygomas

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.236757165.3
2DLD Change Limit1340271626.46620728.0
3Display Results1621620.0463521.7
 (SQL Overall)1786911626.74826480.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.