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

192 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
gremial103915(None) 
gremials1136131gremials
geminal10109902g_eminal
genial74917612g_enial
germinal1147252germinal
predial103815412predial
premeal11310512premeal
proemial1249182proemial
redial74923112_redial
remail85017122_remail
retial64724992_retial
uredial82910482uredial
uremia82910892uremia_
uremias9249502uremias
acromial1248463acromial
aecial84817313_aecial
aerial64625713_aerial
agrestal945653agrestal
anemia82613573anemia_
anemias92512143anemias
areal55928733are__al
arterial8313633arterial
breccial1444693breccial
bromal10313653brom_al
brumal1049503brum_al
chemical1748393chemical
coremia11310363coremia_
cranial92114683cranial
credal9311673cre_dal
creedal1037093creedal
cremini11229063cremini
crestal9312133crestal
criminal1248303criminal
crucial1157893crucial
denial74720513_denial
dermal93614343derm_al
dreidl835233dre_idl
email74715103__email
endemial1146583endemial
eremite9312833eremite
fecial114714623_fecial
ferial94621253_ferial
fetial95716193_fetial
gametal1037603gametal
gavial10310083g_avial
gemma106311773g_emma_
gemmae11507793g_emmae
genital849793g_enital
geoidal936713g_eoidal
geranial949283geranial
gerbil938343gerbi_l
german9611983germ_an
germier10309543germier
germina1038493germina
gharial1137343gharial
gimbal11228813g_imbal
gimmal11247513g_immal
glacial1038143glacial
glial66715433g__lial
gnomical1346683gnomical
gomeral1038833gomeral
graal64316503gr__aal
gradual936943gradual
grail64622873gr_ai_l
grama85620283gram_a_
gramas94317203gram_as
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
grampa115010173grampa_
grampas12399253grampas
graymail1443273graymail
great66034243gre__at
grecize1935663grecize
greeing93613783greeing
greenmail1292883greenmail
greige847203gre_ige
gremlin1035563gremlin
gremlins1136043gremlins
gremmie1264383gremmie
gremmies1355993gremmies
gremmy1454473grem_my
greying124110893greying
greyish1435173greyish
greylag1262553greylag
grill64617893gr__ill
grimier103210433grimier
grimily1336523grimily
griming113612493griming
haemal113811643haem_al
hemal104419803_hem_al
hernial10310433hernial
hiemal11339503hiem_al
irenical1048553irenical
jeremiad1853343jeremiad
medial93819863_medial
menial84223033_menial
mesial84818083_mesial
penial84120893_penial
permian112612283permian
praedial1178763praedial
preanal9310713preanal
preaxial1746973preaxial
prebill1138803prebill
prefixal2044543prefixal
preman104117453prem_an
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixt183510663premixt
premoral1249713premoral
preoral9312673preoral
prepill1147583prepill
pretrial10511983pretrial
prevail1238243prevail
primal104014623prim_al
pyemia1337553pyemia_
pyemias1436803pyemias
pyrexial20234963pyrexial
racial83419243_racial
radial74020393_radial
ramal74622243_ram_al
real45750293_re__al
rebill84713253_rebill
recital9412163_recital
recoal84117973_recoal
rectal84418133_rectal
redia65524483_redia_
rediae74221993_rediae
redials84416883_redials
redias74523603_redias
refill94514053_refill
regal65023793_re_gal
reginal84814293_reginal
regnal74812933_regnal
remails94714563_remails
remain85919863_remain
reman75730153_rem_an
remap95418103_rem_ap
remedial1147543_remedial
remigial1146603_remigial
remind94819793_remind
remint85329973_remint
remise84221953_remise
remiss84216353_remiss
remit75737223_remi_t
remits85622943_remits
remittal1046513_remittal
remix145916553_remi_x
remixt155014853_remixt
removal1236733_removal
renail65020763_renail
renal55929503_re_nal
rental63922023_rental
reoil55321183_reoi_l
repeal84718283_repeal
resail64418733_resail
reseal64819643_reseal
retail65522073_retail
retia55326113_retia_
retinal75318353_retinal
retral64419743_retral
retrial7615553_retrial
reveal94115053_reveal
revisal1038263_revisal
revival1337033_revival
rial45938093_r__ial
ruminal9289993_ruminal
seminal91213403_seminal
serial64625863_serial
special11310303special
telial65815363_telial
terminal1039733terminal
tertial7313863tertial
trenail7410813trenail
trial54926353tr__ial
trivial1038713trivial
uraemia946503uraemia_
uraemias1046043uraemias
ureal56722683ure__al
uredia73610063uredia_
uremic103410513uremi_c
urial54823023ur__ial
venial94218283_venial
vermian12329713vermian
viremia1246083viremia_
viremias1345873viremias
xenial133414903_xenial

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271925.72023431.3
3Display Results1921920.0762526.3
 (SQL Overall)1786911925.93630102.9
 
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.