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

71 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
seesawing134365(None) 
beeswing14255762bees_wing
heehawing1943182heehawing
resawing122311432_resawing
sensating1039252sensating
beeswings15293303bees_wings
declawing1636213declawing
deejaying2142753deejaying
essaying1235033_essaying
jigsawing2141933jigsawing
messaging1345343messaging
overawing16710293overawing
presaging1339393presaging
redrawing1437213redrawing
reesting93118273rees_ting
resaying122512453_resaying
resealing102115673resealing
reseating102421533reseating
resewing122712263_resewing
resowing123111523_resowing
ripsawing1542873ripsawing
sawing104323813___sawing
seafaring1345963seafaring
sealing83528563s_e_aling
seaming103222113s_e_aming
searing83330923s_e_aring
seasoning1037413seasoning
seating84130683s_e_ating
sedating103014113s_edating
seeding93719483see__ding
seedling102610953see_dling
seeing74222143see___ing
seeking124016063see__king
seeling83522003see__ling
seeming103216263see__ming
seeping103817913see__ping
seesaw935973seesaw___
seesawed1243293seesaw_ed
seesaws1034703seesaw__s
seething1239023see_thing
seising84018863seis__ing
sensing84116953sens__ing
serenading1246103serenading
seriating10916403seriating
serrating10513203serrating
sewing103819623s_e__wing
shawing143514883s__hawing
sheafing15329483she_afing
shealing123415463she_aling
shearing123915903she_aring
sheaving154110253she_aving
shewing143812193she__wing
skewing15318723ske__wing
sleaving123310983sle_aving
slewing113311353sle__wing
smearing113511753sme_aring
snawing113612483s__nawing
sneaking133211093sne_aking
sneaping11349493sne_aping
speaking153212493spe_aking
speaning113512243spe_aning
spearing113216103spe_aring
spewing133110453spe__wing
steading103613593ste_ading
stealing93416603ste_aling
steaming114013213ste_aming
stewing113412493ste__wing
strawing122411623s_trawing
swearing123711443swe_aring
sweating123213023swe_ating
sweptwing1841693sweptwing

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.423422437.4
2DLD Change Limit148641717.82618993.2
3Display Results71710.0164437.5
 (SQL Overall)178691718.26521620.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.