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

82 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
outstayed1318593(None) 
outstared10188421outstared
outstated10169811outstated
outplayed1545212outplayed
outprayed1545752outprayed
outshamed1545312outshamed
outskated14176832outskated
outsoared10157592outsoared
outstand938042outsta_nd
outstare81410692outstare_
outstares91610182outstares
outstarted1155072outstarted
outstate81411992outstate_
outstates91710752outstates
outstay1047682outstay__
outstays1156622outstay_s
unstayed12168392_unstayed
guttated10266873gut_tated
ousted73720583ou_st__ed
outbaked1538393out_baked
outbeamed1445363outbeamed
outblazed2195173outblazed
outbraved1566063outbraved
outdared102711513out_dared
outdated1012513193out_dated
outfaced14219463out_faced
outgazed19197733out_gazed
outglared1145923outglared
outgnawed1443623outgnawed
outlawed1238033out_lawed
outleaped1246173outleaped
outpaced13269793out_paced
outplaced1446353outplaced
outraced112414203out_raced
outraged102313103out_raged
outrated92219313out_rated
outraved122511923out_raved
outroared10158113outroared
outsaid81210923outs_a_id
outsailed1037793outsailed
outsay92611873outs_ay__
outsays102710403outs_ay_s
outscored12207073outscored
outserved13136463outserved
outshame1346743outshame_
outshames1445923outshames
outshined1346543outshined
outsinned1045673outsinned
outsized18209743outs_ized
outskate12168013outskate_
outskates13177153outskates
outsmarted1344323outsmarted
outsmiled1245673outsmiled
outsmoked1644773outsmoked
outsnored10175983outsnored
outspanned1343453outspanned
outsped101110323outs__ped
outspeed11117933outs_peed
outstands1045543outstands
outstart81611283outsta_rt
outstarts9176323outstarts
outstaying1446093outstaying
outsteer837553outst_eer
outsteered1143563outsteered
outstood945933outst_ood
outstride1085773outstride
outstrode1065413outstrode
outstudied1242363outstudied
outstunted1143183outstunted
outsulked14124753outsulked
outsware11168843outsware_
outtake11310793out_take_
outtakes12310033out_takes
outtalked1445513out_talked
outtasked1445373out_tasked
outtraded1176983outtraded
overstayed17125853overstayed
stayed104817273___stayed
unstated91615813_unstated
unswayed15155713_unswayed
upstaged12135243_upstaged
upstared11156573_upstared

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641826.57622603.6
3Display Results82820.0302733.3
 (SQL Overall)178691827.02925422.0
 
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.