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

69 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
frivolers154347(None) 
frivoler1443931frivoler_
frivollers1642071frivollers
drivelers1364222drivelers
fribblers16314192fribblers
frijoles1834372frijole_s
frillers11349872fri_llers
frivoled1534042frivole_d
frivoller1542432frivoller_
frivolous1553162frivolous
frivols1334742frivol__s
frizzlers20293672frizzlers
bricoles122610303bricole_s
bridlers11359183bri_dlers
cripplers15314993cripplers
dribblers14274453dribblers
drillers9429723dri_llers
driveler1284693driveler_
drivellers1452953drivellers
drivers114412793driv__ers
favorers1465493f_avorers
fiddlers13328283f_iddlers
filers94623723f_i__lers
fillers104320213f_i_llers
fivers124420923f_iv__ers
flavorers1563983flavorers
flivvers1733113fliv_vers
fribbler15265953fribbler_
fribbles15287713fribble_s
friers94718933fri___ers
frijole1734583frijole__
friller104111743fri_ller_
friskers15337373fri_skers
fritters113810783fri_tters
frivol1235113frivol___
frivoling1644493frivoling
frivolity1843063frivolity
frivolled1642383frivolled
frizers19329553fri__zers
frizzers19335103fri_zzers
frizzler19345843frizzler_
frizzles19297283frizzle_s
grillers93810813gri_llers
grizzlers18253233grizzlers
grovelers13305163grovelers
orioles7412993ori_ole_s
prisoners1147373prisoners
provokers1894203provokers
ravelers113310863_ravelers
revelers113414133_revelers
revilers114011693_revilers
revokers15366753_revokers
revolters12297483_revolters
revolvers15286113_revolvers
riddlers10269103_riddlers
rifflers14336443_rifflers
riflers103512193_ri_flers
rioters73615513_ri_oters
ripplers12337113_ripplers
rivers94626543_riv__ers
riveters11228163_riveters
rivulets1174753_rivulets
snivelers1264533snivelers
travelers12266773travelers
tricolors11125803tricolors
triflers113110213tri_flers
trillers83613493tri_llers
triolets83410143tri_olets
wrigglers14273713wrigglers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641697.42320024.4
3Display Results69690.0332090.9
 (SQL Overall)178691697.87622688.0
 
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.