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

96 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
frivoling164449(None) 
frivolling1742761frivolling
driveling1445762driveling
fribbling1733672fribbling
frilling123011492fri_lling
frivolity1843062frivolity
frizzling2153112frizzling
rivaling1239912_rivaling
bravoing1445993bravo_ing
bridling122610583bri_dling
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
crimpling1645343crimpling
crinkling16145863crinkling
crinoline1147773crinoline
crippling1644093crippling
dribbling1533713dribbling
drilling103311983dri_lling
driveline1345353driveline
drivelling1543983drivelling
driving123910713driv__ing
drizzling1943023drizzling
drooling102610423dr_ooling
failing113521333fai__ling
favoring1596673f_avoring
fiddling14217873f_iddling
filing103823763f_i__ling
filling113520803f_i_lling
firstling1334423firstling
fizzling20264993f_izzling
flavoring1665113flavoring
foiling113317653foi__ling
fooling113117373f__ooling
frazzling2143153frazzling
freckling1934703freckling
friending1495553friending
frigging14268953fri_gging
frighting1736023frighting
frillings13265803fri_llings
fringing133010903fri_nging
frisking16268363fri_sking
fritting123510703fri_tting
frivol1235113frivol___
frivoled1534043frivol_ed
frivoler1443933frivol_er
frivolers1543473frivolers
frivolled1642383frivolled
frivoller1542433frivoller
frivolous1553163frivolous
frivols1334743frivol__s
frizing203310873fri__zing
frizzing2064803fri_zzing
graveling1457383graveling
griddling1333933griddling
grilling103811533gri_lling
grizzling1942843grizzling
groveling1435573groveling
pivoting1436183_pivoting
prickling1836533prickling
prilling113413413pri_lling
prisoning1237643prisoning
provoking1935133provoking
raveling123414373_raveling
resoling92916303_resoling
reveling123117083_reveling
reviling122917213_reviling
revoking1637803_revoking
revolting1339633_revolting
revolving1635843_revolving
revoting12312033_revoting
riddling11249443_riddling
ridgling11258203_ridgling
riesling939013_riesling
riffling1556113_riffling
rifling112815013_ri_fling
riling74227973_ri__ling
rilling84023623_ri_lling
rimpling13219663_rimpling
rioting82716393_ri_oting
rippling13197573_rippling
rivalling1335963_rivalling
riveting12139443_riveting
riving104521423_riv__ing
shriveling1743253shriveling
sniveling1336033sniveling
swiveling1634573swiveling
traveling1349053traveling
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
voling103918023___voling
wriggling1533813wriggling
wrinkling17144953wrinkling

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 Filter1786911486410.423422437.4
2DLD Change Limit148641966.31323545.2
3Display Results96960.0462087.0
 (SQL Overall)178691966.78226347.8
 
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.