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

141 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
aglitter93509(None) 
glitter84211801_glitter
admitter1135112admitter
aflutter1163812aflutter
aglimmer1342342aglimmer
allotter866472allotter
atwitter1143672atwitter
flitter103413902_flitter
glister84013342_glister
glitters93710542_glitters
glittery12375612_glittery
gritter83913352_gritter
litter64324852__litter
slitter73615872_slitter
splitter10348442splitter
abetter958323a_better
abutter957513a_butter
acquitter2043553acquitter
admitted1234763admitted
admittee1145133admittee
admitters1244553admitters
afflicter1742823afflicter
agilities10810973agilities
aginner844663ag_inner
agisted938203ag_isted
agitate8312063ag_itate_
agitated1038413ag_itated
agitates9310873ag_itates
agitator946713ag_itator
alerter72111513a_lerter
aliener71011193a_liener
aligner8108303a_ligner
aliner65621983a_li_ner
allotted986873allotted
allottee887123allottee
allotters965563allotters
alter54828503a_l__ter
anointer837823anointer
antilitter1045333antilitter
aplite8316393apli_te_
aplites9314933apli_tes
arbiter939933arbi_ter
assister836753assister
awaiter1057443awai_ter
belittler1142493belittler
bitter84622673__bitter
blatter94415653_blatter
blister94415313_blister
blither124812173_blither
blitzer18447663_blitzer
blotter94612853_blotter
chitter124112963_chitter
clatter94014973_clatter
clutter94211653_clutter
critter94113033_critter
embitter12245623embitter
emitter93211083_emitter
enlister847803enlister
filister1137403filister
fitter94120033__fitter
flatter103815963_flatter
flirter10318673_flirter
flitted114011643_flitted
flitters114312173_flitters
flutter104012093_flutter
fritter103912773_fritter
gaiter73819503_gai_ter
galette84212693galette_
galettes93111153galettes
ganister9178993ganister
garotter965943garotter
getter74117613_g_etter
gitted84015053_g_itted
gittern8337503_g_ittern
glibber1235163_glibber
glider84614263_gli_der
glimmer12437713_glimmer
glinted9399373_glinted
glintier945703_glintier
glisten8418083_glisten
glisters93912603_glisters
glittered11195403_glittered
glitzed18375493_glitzed
glitzes17367563_glitzes
glitzier1833593_glitzier
gloater83711013_gloater
glutted937243_glutted
goiter74116203_goi_ter
grifter113810493_grifter
grister83915413_grister
gritted94110903_gritted
gritters94210633_gritters
grittier9316263_grittier
gutter73817703_g_utter
hitter94419863__hitter
igniter8147663igni_ter
imbitter12265273imbitter
jitter133314993__jitter
klister113410643_klister
knitter11348133_knitter
latter65027893__latter
letter63722583__letter
lifter93814813__lifter
linter64625333__linter
lister64527253__lister
liter54736343__li_ter
lither94520953__lither
litten64014873__litten
litters73422563__litters
littery103710483__littery
littler7348553__littler
lotter64025603__lotter
magister1136283mag_ister
omitter9298503_omitter
outglitter1181993outglitter
platter93917413_platter
plotter94113663_plotter
politer92417073poli_ter
quitter162910753_quitter
reletter81311023reletter
remitter102810323remitter
ritter63822413__ritter
sitter63323383__sitter
skitter113810393_skitter
slither104112983_slither
slitted83513313_slitted
slitters84014133_slitters
slittier837003_slittier
slotter73314443_slotter
spitter94015183_spitter
splatter10348883splatter
splinter10329703splinter
splitters11307323splitters
splutter10357443splutter
titter63421163__titter
twitter10278093_twitter
uglier748953ugli__er
uglifier1244503uglifier
unbitter1046173unbitter
uplifter1363903uplifter
whitter139110893_whitter

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.1731032896.0
2DLD Change Limit1461621417.56319325.9
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.79922912.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.