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

96 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
outfasting144633(None) 
outfeasting1543841outfeasting
outlasting1137521outlasting
outwasting1446431outwasting
outacting1239212out_acting
outasking1437312out_asking
outboasting1444242outboasting
outdating11810862outda_ting
outeating10814492outea_ting
outfabling1644542outfabling
outfacing1578112outfa_cing
outfawning1744222outfawning
outfishing1765992outfishing
outfitting1465822outfitting
outfooting1445652outfooting
outgassing1245352outgassing
outpassing1355852outpassing
outrating10916402outra_ting
outtasking1545722outtasking
outwaiting1446732outwaiting
contrasting1459353contrasting
fasting114522833___fasting
mutating112211753mut_a_ting
nutating92411953nut_a_ting
obtesting1245883obt_esting
ousting84021353ou___sting
outadding1235793out_adding
outbaking1638233outba_king
outbarking1746213outbarking
outbawling1644933outbawling
outclassing1443913outclassing
outdancing1445223outdancing
outdaring1179723outda_ring
outearning1146743outearning
outfast101412123outfast___
outfasted13147173outfast_ed
outfasts11117233outfast__s
outfeeling1445073outfeeling
outfencing1645293outfencing
outfighting1943313outfighting
outfinding1545873outfinding
outfiring1338163outf_iring
outflanking1943413outflanking
outfloating1544363outfloating
outflowing1744713outflowing
outflying1635343outf_lying
outfooling1445473outfooling
outfoxing20115603outf_oxing
outgaining1237093outgaining
outgazing2037143outga_zing
outgushing1544573outgushing
outhitting1446333outhitting
outhunting1446143outhunting
outhustling1542593outhustling
outjutting1844263outjutting
outkissing1544323outkissing
outlawing1337933outla_wing
outlaying1338543outla_ying
outmanning1345543outmanning
outmastering1552953outmastering
outpacing1478363outpa_cing
outpainting1445153outpainting
outpushing1644773outpushing
outputting1345083outputting
outquoting2064743outquoting
outracing12912163outra_cing
outraging111010883outra_ging
outraising1139903outraising
outranging1238003outranging
outranking1537673outranking
outraving13910133outra_ving
outrooting1147933outrooting
outrushing1446403outrushing
outsailing1137563outsailing
outsaying1338703outsa_ying
outsing83320463out__s_ing
outsitting1147133outsitting
outskating1536853outskating
outsmarting1444383outsmarting
outstarting1245013outstarting
outstating1139363outstating
outswing1259283out__swing
outtalking1545483outtalking
outvaluing1444223outvaluing
outvaunting1542893outvaunting
outvoting1336823out_voting
outwalking1845283outwalking
outwarring1445363outwarring
outwishing1765793outwishing
outwitting1445553outwitting
outwriting1447183outwriting
retasting102513413ret_asting
sulfating1338063sulfa_ting
tasting84624213__t_asting
toasting93410583__toasting
upcasting1434823_upcasting

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 Filter1786911406030.420425454.8
2DLD Change Limit140603966.37622051.9
3Display Results96960.0462087.0
 (SQL Overall)178691966.84226116.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.