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

181 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
gleamier114491(None) 
gleamer10328511gleam_er
beamier113411942_beamier
blearier1037332blearier
creamier12319062creamier
dreamier11287292dreamier
flamier123112142fl_amier
gamier93617932g__amier
gemmier12337382g_emmier
germier10309542g_ermier
glacier103911292gl_acier
gladier93810992gl_adier
glarier84112202gl_arier
glazier17409352gl_azier
gleamed11327932gleam_ed
gleamers11306562gleam_ers
gleamiest1235302gleamiest
gleaming12277932gleaming
gleaner8379772glea_ner
gleetier934912gleetier
gloomier1135092gloomier
greasier9298082greasier
leadier83212722_leadier
leafier10329832_leafier
leakier114010992_leakier
learier73415662_learier
leavier10319992_leavier
loamier9349162_loamier
seamier93114632_seamier
sleazier1735122sleazier
steamier1048302steamier
beadier103513913_beadier
beakier134012163_beakier
blamer104417143bl_am_er
bleacher15358883bleacher
bleaker133510533blea_ker
bleater94515303blea_ter
bloomier1275783bloomier
claimer11279883cl_aimer
clamber133311733cl_amber
clammer134211793cl_ammer
clammier1435843clammier
clamper134012993cl_amper
clavier1239173cl_avier
clayier1248323cl_ayier
cleaner93712303clea_ner
cleanlier1143363cleanlier
cleanser10356313cleanser
clearer93710823clea_rer
cleaver124110803clea_ver
creakier14328333creakier
creamer113714083cream_er
creasier103210193creasier
dreamer104110843dream_er
drearier9297923drearier
easier64218463__easier
elmier839813__elmier
flakier143910203fl_akier
flamer114919123fl_am_er
flawier13378733fl_awier
flaxier17337983fl_axier
fledgier1333683fledgier
fleecier1334763fleecier
fleshier1435603fleshier
floatier1136983floatier
foamier12339003_foamier
freakier15246483freakier
gambier124711973g__ambier
gamer84928943g__am_er
gammer1112318333g__ammer
gammier123711193g_ammier
gasalier936443gasalier
geekier12286393g_eekier
glaciers11277893gl_aciers
gladder10398313gl_adder
gladlier1034343gladlier
glair65313553gl_a_i_r
glaire74411293gl_a_ire
glairier944833glairier
glamor958183gl_am_or
glamour1065133gl_amour
glancer103710073gl_ancer
glassier9289083glassier
glazer164212263gl_a_zer
glaziers18406563gl_aziers
glaziery21413693gl_aziery
gleam86916733gleam___
gleams94812253gleam__s
gleamy12398113gleam__y
gleaned9349423glea_ned
gleaners9348073glea_ners
gleaning10269323gleaning
gleemen1035723gleem_en
glimmer12437713gl_immer
glintier945703glintier
glitzier1833593glitzier
gloaming12268013gloaming
gloater83711013gloa_ter
globbier1334243globbier
gloppier1354673gloppier
glossier9358203glossier
gluier7310263gl__uier
glummer12417983gl_ummer
glumpier1334873glumpier
grapier103712603g_rapier
grazier173611133g_razier
greaser83913083grea_ser
greater84416493grea_ter
greedier1036083greedier
greenier938713greenier
gremmie1264383gremmie_
gremmies1355993gremmies
grenadier1144093grenadier
grimier103210433g_rimier
gummier12349473g_ummier
headier113212953_headier
heavier13429423_heavier
klezmer2231933klezm_er
lacier84020093_l_acier
lakier104716273_l_akier
lamber104418493_l_amber
lambier113611643_l_ambier
lamer75233703_l_am_er
lazier154214613_l_azier
leacher124014843_leacher
leachier1337253_leachier
leader74824653_lea_der
leaguer835793_leaguer
leaker104620073_lea_ker
leaner64022193_lea_ner
leaper88118943_lea_per
learner7319383_learner
leaser65322673_lea_ser
leather103815783_leather
leaver94321513_lea_ver
ledgier9458493_ledgier
leerier73111503_leerier
leggier9368233_leggier
levier94013873_le_vier
limier83518723_l_imier
mealier93015903_mealier
meatier93214613_meatier
oleander936403oleander
oleaster837263oleaster
peakier134411443_peakier
peatier94017233_peatier
phlegmier1741173phlegmier
platier93716293pl_atier
pleader103511753plea_der
pleaser93912343plea_ser
pleater93916333plea_ter
pleather1356653pleather
plumier113510043pl_umier
plummier1434123plummier
premier113515633pre_mier
queasier1734473queasier
queazier2642833queazier
readier83117423_readier
reamer84325213_ream_er
recamier1237603recamier
rheumier1342513rheumier
seamer84223613_seam_er
slammer113913033sl_ammer
slatier74016813sl_atier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
slimier93212013sl_imier
slummier1235473slummier
smearier1036953smearier
sneakier1245143sneakier
steadier937313steadier
steamer93313093steam_er
stemmier1245253stemmier
streamier1155763streamier
sweatier1147033sweatier
tearier73815613_tearier
tweakier1533143tweakier
uneasier836963uneasier
vealier102712173_vealier
wearier103613283_wearier

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621817.04620744.0
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.26524596.1
 
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.