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 “flummoxing” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
flummoxing25598(None) 
flamming16357153flamm__ing
fluming133512793flu_m__ing
flummox2141413flummox___
flummoxed244893flummox_ed
flummoxes2351503flummox_es
flumping16287583flu_m_ping
fluxing18398923flu___xing
plummeting1742103plummeting
slumming13278383slumm__ing
summoning14115693_summoning
bluming123511284blu_m__ing
bumming143410784_bumm__ing
chumming18366204chumm__ing
clamming15329374clamm__ing
clamoring1477424cl_amoring
climaxing2143494cl_imaxing
clumping15319884clu_m_ping
commixing2345194_commixing
commoving1944984_commoving
drumming14265784drumm__ing
dummying17263724_dumm_ying
filmgoing1641714filmgo_ing
filmmaking2242094filmmaking
flambeing1743934fl_ambeing
flaming134216444fl_am__ing
flavoring1665114fl_avoring
flehmening1942244flehmening
flemishing1943494flemishing
flexing18358994fl___exing
flooding13238964fl__ooding
flooring12259884fl__ooring
flowing143411764fl___owing
flubbing16275884flu__bbing
fluffing14275414flu__ffing
fluidising1542584fluidising
fluidizing2443234fluidizing
fluking154410514flu___king
flummeries1743764flummeries
flunking16317774flu__nking
fluorin1037234flu__orin_
fluorine1147814flu__orine
fluorins1137344flu__orins
flurrying16162804flu_rrying
flushing15288834flu__shing
flustering14105934flustering
fluting113815094flu___ting
fluttering14106294fluttering
flyblowing225914flyblowing
foxing175012434f____oxing
fulmining1554404f_ulmining
fumbling16208164f_u_mbling
fuming124013294f_u_m__ing
furrowing1644064f_urrowing
gammoning1545064_gammoning
glimmering1643714glimmering
glomming14275924glomm__ing
grummeting1642454grummeting
gumming133810194_gumm__ing
humming153310674_humm__ing
hummocking24101864_hummocking
humoring1456854_hu_moring
immixing2043544__immixing
lamming123014584_lamm__ing
lemming12269394_lemm__ing
loxing143615274_l___oxing
lumbering14117934_lumbering
lummox1733054_lummox___
lummoxes1942554_lummox_es
lumping123314644_lu_m_ping
mumming114010024_mumm__ing
mummying15263724_mumm_ying
outboxing19155764_outboxing
outfoxing20115604_outfoxing
outmoding1346514_outmoding
outmoving1545604_outmoving
plumbing15286434plu_m_bing
pluming123412044plu_m__ing
plumpening1742444plumpening
plumping15277634plu_m_ping
pummeling1643604_pummeling
resummoning1671954resummoning
rummaging1543364_rummaging
rumoring1136984_ru_moring
scumming15256794scumm__ing
slamming133310004slamm__ing
slimming13288094slimm__ing
slumbering15105324slumbering
slumping13359974slu_m_ping
stumming13347674stumm__ing
summating1437944_summating
summering1458754_summering
summing122912384_summ__ing
summiting1445794_summiting
summonsing1543094_summonsing
unboxing1836114__unboxing
unmixing1835544__unmixing
unmoving1436254__unmoving

Search took 10 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 Filter1786911614500.453394461.4
2DLD Change Limit161450989.25017454.1
3Display Results98980.0462130.4
 (SQL Overall)178691989.74918329.2
 
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.