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

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

44 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
outgalloping16591(None) 
galloping1356253___galloping
outgallop1241743outgallop___
outgalloped155933outgallop_ed
outgallops1351213outgallop__s
outglowing1544683outg__lowing
escalloping1652154_escalloping
galoping1258024___ga_loping
outbalancing1751644outbalancing
outbawling1644934outbawl__ing
outblooming1642724out_blooming
outbullying1752294outbull_ying
outfabling1644544outfabl__ing
outflowing1744714out__flowing
outgaining1237094outga__ining
outgambling1742134outga_mbling
outgassing1245354outga__ssing
outgazing2037144outga___zing
outglaring1246274outg__laring
outgleaming1542534outg_leaming
outgoing1039274outg___o_ing
outgrowing1555644outg__rowing
outkilling1545264outkill__ing
outleaping1346204out__leaping
outloving1336714out___loving
outpolling1346214outpoll__ing
outpulling1344824outpull__ing
outrolling1137534outroll__ing
outsailing1137564outsail__ing
outsavoring1542964outsa_voring
outscooping1643194out_scooping
outselling1188024outsell__ing
outsleeping1443294out_sleeping
outtalking1545484outta_l_king
outtelling11107134outtell__ing
outvaluing1444224outva_l_uing
outwalking1845284outwa_l_king
outwilling1445804outwill__ing
outyelling14116144outyell__ing
outyelping16123974out_yel_ping
scalloping1543954__scalloping
tallowing1366294__t_allowing
unhallowing1851424_unhallowing
walloping1545594___walloping

Search took 7 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.423422437.4
2DLD Change Limit124790446.17020225.3
3Display Results44440.0162750.0
 (SQL Overall)178691446.60927037.5
 
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.