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

183 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
zaftig193325(None) 
zoftig1932971zoftig
hafting144014172hafting
maftir1136492maftir
rafting113815752rafting
wafting143911662wafting
zaffir21395512zaffir
actin74922553_actin
acting95920983_acting
affix1836003_affix
afrit8323173_afrit
aft66849013_aft__
after85719793_after
anti45536363_anti_
antic75728863_antic
anting75827023_anting
antis55033313_antis
astir55517093_astir
attic75618353_attic
azotic172711633azotic
baffing164011603baffing
bagwig1343083bagwig
baiting103918883baiting
basting104227203basting
batik11614733ba_tik
bating95132253ba_ting
battik1238093battik
batting104422273batting
bawtie113812143bawtie
cacti9318643cacti_
caftan111710123caftan
cantic103920543cantic
canting104725903canting
carting104228283carting
casting104628343casting
cattie85221023cattie
catting103922643catting
crafting143710173crafting
daffing15369733daffing
daft85537253daft__
dafter104813343dafter
daftly1335443daftly
darting94020663darting
dating85326483da_ting
dautie72914703dautie
dauting93814763dauting
dawtie103011093dawtie
dawting123610673dawting
drafting13339413drafting
earwig10114703earwig
easting84924303easting
eating75134403ea_ting
farting114120753farting
fasting114522833fasting
fating105328673fa_ting
fatting113818703fatting
fig76242833__f_ig
frig85424503__frig
gaffing15379733gaffing
gaiting93716583gaiting
gasting95022763gasting
gating84826953ga_ting
gifting123810893gifting
grafting13319623grafting
haffit1538533haffit
hafiz20611213haf_iz
haft105941843haft__
hafted134713833hafted
hafter124815883hafter
hafts116219463haft_s
halting114419073halting
hanting114124483hanting
haptic13511893haptic
hasting114725193hasting
hating104929713ha_ting
hatting113920233hatting
hefting144510913hefting
kaffir16345303kaffir
kafir12488903kaf_ir
kaftan13185823kaftan
karting123716063karting
lactic10713493lactic
lasting84725243lasting
lati46438273la_ti_
latigo73410013la_tigo
lattin64316223lattin
lifting113313273lifting
lofting113311313lofting
maffia14327203maffia
mafia104418033maf_ia
mafic125615463maf_ic
maftirs1236043maftirs
malting103219083malting
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
martin84122523martin
marting103325013marting
mastic103119173mastic
masting104325823masting
mastix152310513mastix
matin75132853ma_tin
mating94832913ma_ting
mattin84416633mattin
matting103620143matting
mufti10610543mufti_
muftis1158053muftis
naffing14359033naffing
nastic82915973nastic
pantie84326473pantie
panting104025423panting
parting103527383parting
pastie85525523pastie
pastil85018323pastil
pasting103826553pasting
pastis84924323pastis
patin76832853pa_tin
patio74426353pa_tio
pattie84020963pattie
patting103722343patting
raffia12287703raffia
raft76245913raft__
rafted104714703rafted
rafter94517583rafter
rafts87820633raft_s
ragtag836643ragtag
ramtil8311033ramtil
ranting84025413ranting
rating74938703ra_ting
ratio55227583ra_tio
ratting83822363ratting
rifting113515003rifting
saltie63422433saltie
salting84120793salting
santir6315253santir
sati45539333sa_ti_
satin55935223sa_tin
sating74735453sa_ting
satis55633683sa_tis
shafting15278683shafting
sifting113014593sifting
softie93312483softie
tactic10612753tactic
taffia12286903taffia
tafia84215493taf_ia
tarting84222653tarting
tasting84624213tasting
tattie64817513tattie
tatting84019523tatting
tauting83316383tauting
tautog765713tautog
tufting11289873tufting
vatic10316423va_tic
vatting113614853vatting
waffie15338563waffie
waffing173710243waffing
waft106139003waft__
waftage14115323waftage
wafted134012143wafted
wafter124114613wafter
wafts116920553waft_s
waiting113618953waiting
wanting114220173wanting
wasting114422843wasting
yaffing17337823yaffing
yautia937253yautia
zaddik2134243zaddik
zaffar21385043zaffar
zaffer21397153zaffer
zaffirs22375663zaffirs
zaffre21354663zaffre
zag137539473za___g
zagging193210453zagging
zamia165115213za_mia
zapping213211473zapping
zaptiah2144293zaptiah
zaptieh2144563zaptieh
zayin174512043za_yin
zeatin15412823zeatin
zesting174515333zesting
zig136931903z___ig
ziti136022373z_iti_
zitis145815583z_itis

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161834.76323664.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911835.20234350.4
 
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.