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

114 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
flouncing153390(None) 
flouncings1641671flouncings
frouncing1534761frouncing
bouncing13318772_bouncing
enouncing1245572enouncing
flaunting1335042flaunting
floccing16306022flo_ccing
flouncier1442482flouncier
flouring123010142flou_ring
flouting122610472flou_ting
flunking16317772fl_unking
founding133010782f_ounding
jouncing18336852_jouncing
lounging1036752_lounging
pouncing13318882_pouncing
trouncing1235152trouncing
abounding1335193abounding
amounting1236643amounting
announcing1342993announcing
beduncing1543913beduncing
blousing1138793blou_sing
blunging12328413bl_unging
blunting11319843bl_unting
bounding123012133_bounding
cloning103215473clo_n_ing
clonking153810153clo_nking
clouding12269493clou_ding
clouring112811273clou_ring
clouting113011683clou_ting
clowning14307253clown_ing
clunking15329433cl_unking
counting113115263_counting
denouncing1443883denouncing
eloining9310443eloin_ing
fencing132411133f__encing
financing1544063financing
flanging132710583fl_anging
flanking164211083fl_anking
fleecing14347573fl_eecing
flenching18296703fl_enching
flensing1246973fl_ensing
flinching18245823fl_inching
flinging133310053fl_inging
flinting123412343fl_inting
floating123111883flo_ating
flocking183410873flo_cking
flogging14329173flo_gging
flooding13238963flo_oding
flooring12259883flo_oring
flopping16388773flo_pping
flossing12247903flo_ssing
flounce1235413flounc__e
flounced1433803flounc_ed
flounces1335103flounc_es
flounciest1542563flounciest
flouncy1543673flounc__y
floundering1642483floundering
flowering1636053flowering
flowing143411763flo__wing
flubbing16275883fl_ubbing
fluffing14275413fl_uffing
fluking154410513fl_u_king
fluming133512793fl_u_ming
flumping16287583fl_umping
flushing15288833fl_ushing
fluting113815093fl_u_ting
fluxing18398923fl_u_xing
foining113013453f_oin_ing
fonding123815423f_o_nding
forcing134013753f_o_rcing
fouling113315373f_ou_ling
foundling1435203f_oundling
fronting12310443fro_nting
frowning15307833frown_ing
funding124113663f__unding
funking154013023f__unking
funning113813613f__unning
glancing1247063gl_ancing
glouting10379693glou_ting
glunching16174083gl_unching
grounding1236083grounding
hounding132610053_hounding
jauncing18314783_jauncing
lancing103314123_l_ancing
launching1544783_launching
loaning83614833_loan_ing
longing93915783_lo_nging
louping104313983_lou_ping
louring83916503_lou_ring
lousing83817733_lou_sing
louting83719383_lou_ting
lunching143110003_l_unching
lunging93714213_l_unging
lunting83817743_l_unting
mounding123311263_mounding
mounting112711813_mounting
plonking15358563plo_nking
ploughing16203673ploughing
plunging12357673pl_unging
plunking15328483pl_unking
poncing122913583_po_ncing
pounding123311473_pounding
renouncing1345103renouncing
rounding102812283_rounding
sconcing1338263sco_ncing
slouching15195723slouching
sloughing14244753sloughing
sluicing1137063sl_uicing
sounding102712873_sounding
sourcing1158353_sourcing
stounding1136233stounding
swounding1434133swounding
swouning12246563swoun_ing
wounding13249403_wounding

Search took 9 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.326548131.9
2DLD Change Limit1486411148.45317584.4
3Display Results1141140.0502280.0
 (SQL Overall)1786911148.82920239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.