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

85 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
outdistancing17685(None) 
distancing1447083___distancing
outdancing1445223outd___ancing
outdistance1452013outdistanc__e
outdistanced1651263outdistanc_ed
outdistances1551763outdistanc_es
outstanding1344553out__standing
outbalancing1751644out_balancing
outdesigning1551534outdesign_ing
outspanning1443564out__spanning
outstaring1137804out__sta_ring
outstarting1245014out__starting
outstating1139364out__sta_ting
outstaying1446094out__sta_ying
outstunting1243784out__stunting
audiotaping1551655au_diota_ping
disbanding1545585___disbanding
discanting1449455___discanting
distaining1248905___distaining
distasting1248025___distasting
distending1348335___distending
hardstanding1851695hard_standing
instancing1344645___instancing
outbitching1992865outbi_t_ching
outdaring1179725outd___a_ring
outdating11810865outd___a_ting
outdebating1543295outd_eba_ting
outdragging1543425outd__ragging
outdrawing1546025outd__ra_wing
outdreaming1544235outd_rea_ming
outdrinking1743965outd__rinking
outfacing1578115out___fa_cing
outfasting1446335outfast___ing
outfencing1645295out___fencing
outfinding1545875outfi___nding
outfishing1765995outfis___hing
outfitting1465825outfi_t__ting
outflanking1943415out__flanking
outhitting1446335outhi_t__ting
outhustling1542595outhust__ling
outjinxing2543965outji___nxing
outkissing1544325outkis___sing
outlasting1137525outlast___ing
outlining10310505outli___n_ing
outmanning1345545out___manning
outmastering1552955outmast_ering
outpacing1478365out___pa_cing
outpitching1962975outpi_t_ching
outpitying1644775outpi_t__ying
outplacing1546195out__pla_cing
outplanning1463835out__planning
outracing12912165out___ra_cing
outranging1238005out___ranging
outranking1537675out___ranking
outringing1247815outri___nging
outrivaling1543755outri_va_ling
outrivalling1651705outri_valling
outsailing1137565out__s_ailing
outsaying1338705out__s_a_ying
outshaming1645665out__sha_ming
outshining1446535out__shin_ing
outsinging1246275out__s_inging
outsinning1146175out__s_inning
outsitting1147135outsi_t__ting
outskating1536855out__ska_ting
outsmarting1444385out__smarting
outsoaring1137705out__soa_ring
outsourcing1452975out__sourcing
outspending1544315out__spending
outstandingly1861025out__standingly
outsteering1244555out__steering
outstriding1344205out__striding
outstriving1543795out__striving
outstudying1642155out__studying
outswinging1643435out__swinging
outtalking1545485out___talking
outtasking1545725out___tasking
outthanking1943435out__thanking
outwasting1446435outwast___ing
outwinding1545655outwi___nding
outwishing1765795outwis___hing
outwitting1445555outwi_t__ting
understanding1673775_understanding
upstanding1443715_u__pstanding
withstanding2061155wit_hstanding

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 Filter1786911247900.393454684.5
2DLD Change Limit124790858.10615394.8
3Display Results85850.0461847.8
 (SQL Overall)178691858.54520911.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.