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

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

83 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
outgeneraling156128(None) 
outgeneral1161963outgeneral___
outgeneraled1461163outgeneral_ed
outgenerals1251403outgeneral__s
degenerating1545664_degenerating
generating12310384___generating
intenerating1346724int_enerating
outfeeling1445074outfe_e__ling
outgleaming1542534outg_le_aming
outgnawing1544434outg_n__awing
regenerating1446334_regenerating
generalise11178125___generalise
generalising1454105___generalising
generalist11169425___generalist
generality1446195___generality
generalize20198455___generalize
generalizing2346355___generalizing
itinerating1245235_it_inerating
lateraling11148805lat___eraling
mutineering1453235mutineer__ing
outbeaming1546045out__be_aming
outbleating1444885out_ble_ating
outbraving1646165out___braving
outbrawling1743705out___brawling
outcapering1643335outcaper__ing
outcheating1744875out_che_ating
outcrawling1743655out___crawling
outdebating1543295out__debating
outdrawing1546025out___drawing
outdreaming1544235out_dre_aming
outdueling1244595out_due__ling
outduelling1342975out_due_lling
outearning1146745out_e_ar_ning
outeating10814495out___e_ating
outfencing1645295outfen___cing
outgambling1742135outg__ambling
outgazing2037145outg____azing
outglaring1246275outg___laring
outgrowing1555645outg___rowing
outguessing1342775outg_ue_ssing
outgunning1244245outgun___ning
outhandling1643465outhan__dling
outhearing1438445out__he_aring
outhomering1743905outhomer__ing
outkeeping1744265outke_e__ping
outleading1237135out__le_ading
outleaping1346205out__le_aping
outlearning1243545outle_ar_ning
outpeopling1653175out__peopling
outpowering1743175outpower__ing
outpraying1646525out___praying
outracing12912165out____racing
outraging111010885out____raging
outrating10916405out____rating
outraving13910135out____raving
outreading1239285out__re_ading
outrivaling1543755out__rivaling
outscreaming1752195outscre_aming
outseeing1038335outse_e___ing
outselling1188025out__se_lling
outserving1446745out__ser_ving
outsmelling1453565out_sme_lling
outsnoring1145615out_snor__ing
outsparkling1951655out_sparkling
outspeaking1844175out_spe_aking
outspelling1444145out_spe_lling
outspreading1652715outspre_ading
outsteering1244555outsteer__ing
outswearing1544075out_swe_aring
outtelling11107135out__te_lling
outtowering1542855outtower__ing
outtrading1247155out___trading
outwearing1437185out__we_aring
outwearying1843205outwe_ar_ying
outweeping1644465outwe_e__ping
outwhirling1842465out_whir_ling
outwrestling1651695out_wrestling
outyelling14116145out__ye_lling
overgeneralize27193445overgeneralize
oxygenating2352355oxygen__ating
subgeneration1652605subgeneration
subgenerations1752515subgenerations
venerating14410055___venerating

Search took 10 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790839.00013865.6
3Display Results83830.0461804.3
 (SQL Overall)178691839.18619452.5
 
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.