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

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

84 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
frumpily184332(None) 
grumpily1643461grumpily
bumpily1665652_bumpily
crumply16336092crump_ly
dumpily1566232_dumpily
fruitily1445142fruitily
frumpier1534172frumpier
frumpish1843502frumpish
frumpy16466882frump__y
glumpily1643592glumpily
jumpily2174982_jumpily
lumpily1476562_lumpily
rumply13348572_rump_ly
campily1638273_campily
chummily2042843chummily
clumsily1544003clumsily
creepily1574953creepily
crispily1574693crispily
croupily1544743croupily
crumbly16347523crum_bly
crumping15319903crumping
crumple13368363crump_le
crusily12199093cru_sily
crustily13328173crustily
drippily1643033drippily
droopily1443943droopily
drumly1235703drum__ly
family143311703f_am_ily
faultily1474523faultily
filmily1535733film_ily
flimsily1643283flimsily
floppily1843773floppily
fluffily1652923fluffily
flukily1735213flu_kily
flumping16287583flumping
foamily1546543foam_ily
freakily1835003freakily
frenzily2343733frenzily
friskily1834503friskily
frizzily2253143frizzily
frostily1436693frostily
frothily1745303frothily
frowzily2642673frowzily
fructify1942353fructify
frugally1544403frugally
fruity12429693fru__ity
frumenty1644573frumenty
frump126912563frump___
frumpiest1634543frumpiest
frumps13479783frump__s
fuggily1534963f_uggily
funkily1736513f_unkily
funnily1336373f_unnily
furmity1535183furm_ity
furrily1337613f_urrily
fussily13267603f_ussily
fustily133111373f_ustily
fuzzily2145073f_uzzily
grimily1336523grim_ily
grubbily1642973grubbily
gruffily1863083gruffily
grumbly15355403grum_bly
grumphy18443623grump_hy
grumpier1334803grumpier
grumping14266903grumping
grumpish1643763grumpish
grumpy14498153grump__y
plumply1634223plump_ly
preppily1444593preppily
promptly1743913promptly
pulpily1436103_pulpily
ropily113312443_r_opily
roupily1246653_roupily
ruddily1236303_ruddily
rumbly134412163_rum_bly
rumple103913013_rump_le
rustily103112993_rustily
ruttily10338613_ruttily
scrimpily1842553scrimpily
scummily1743303scummily
skimpily1963053skimpily
trumpery1533613trumpery
trumping13308733trumping
trustily11257103trustily

Search took 7 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.436409841.7
2DLD Change Limit146162846.33023090.4
3Display Results84840.0302800.0
 (SQL Overall)178691846.79626293.6
 
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.