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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
outlasting113752(None) 
outfasting1446331outfasting
outwasting1446431outwasting
outacting1239212out_acting
outasking1437312out_asking
outboasting1444242outboasting
outclassing1443912outclassing
outdating11810862outda_ting
outeating10814492outea_ting
outfeasting1543842outfeasting
outgassing1245352outgassing
outlawing1337932outla_wing
outlaying1338542outla_ying
outpassing1355852outpassing
outrating10916402outra_ting
outtasking1545722outtasking
outwaiting1446732outwaiting
ballasting1345303ballasting
blasting114013433__blasting
butylating1644583butyla_ting
contrasting1459353contrasting
lasting84725243___lasting
mutating112211753mut_a_ting
mutilating1349083mutila_ting
nutating92411953nut_a_ting
obtesting1245883obt_esting
ousting84021353ou___sting
outadding1235793out_adding
outbaking1638233outba_king
outbarking1746213outbarking
outbawling1644933outbawling
outblazing2245593outbla_zing
outbleating1444883outbleating
outblessing1443453outblessing
outblushing1743013outblushing
outdancing1445223outdancing
outdaring1179723outda_ring
outearning1146743outearning
outfabling1644543outfabling
outfacing1578113outfa_cing
outfawning1744223outfawning
outfishing1765993outfishing
outfitting1465823outfitting
outflanking1943413outflanking
outfloating1544363outfloating
outfooting1445653outfooting
outgaining1237093outgaining
outgazing2037143outga_zing
outglaring1246273outgla_ring
outgushing1544573outgushing
outhitting1446333outhitting
outhunting1446143outhunting
outhustling1542593outhustling
outjutting1844263outjutting
outkissing1544323outkissing
outlain71212613outla__in_
outlast71015443outlast___
outlasted10128353outlast_ed
outlasts8108713outlast__s
outlaughing1642463outlaughing
outleading1237133outleading
outleaping1346203outleaping
outlearning1243543outlearning
outlining10310503outl_ining
outliving1337793outl_iving
outloving1336713outl_oving
outlying1248813outl__ying
outmanning1345543outmanning
outmastering1552963outmastering
outpacing1478363outpa_cing
outpainting1445153outpainting
outplacing1546193outpla_cing
outplanning1463833outplanning
outplaying1645963outpla_ying
outplotting1443753outplotting
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
ovulating1336953ovula_ting
oxalating1745803oxala_ting
pulsating1236343pu_lsating
retasting102513413ret_asting
sublating12310983subla_ting
tasting84624213__t_asting
toasting93410583__toasting
umlauting1243163_umlauting
unlashing1336493_unlashing
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.423422437.4
2DLD Change Limit1406031145.57625215.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.04529560.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.