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

106 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
outplays1324684(None) 
outlays102610901out_lays
outplans10259531outplans
outplay12267721outplay_
outprays13236931outprays
gunplays1442712gunplays
outclass1037202outclass
outlaws10249602out_laws
outlay92711792out_lay_
outpass939712outp_ass
outplace1257912outplace
outplaces1347742outplaces
outplan9249442outpla_n
outplayed1545212outplayed
outplods11105612outplods
outplots1086362outplots
outpray12268082outpray_
outsays102710402out_says
outstays1156622outstays
airplays1344533airplays
byplays1743103_byplays
cullays12347703cu_llays
cutaways1643813cutaways
cutlas8313103cut_la_s
cutlass938013cut_lass
displays1446293displays
downplays1842503downplays
endplays14123773endplays
foreplays1745043foreplays
gunplay1343233gunplay_
misplays1555543misplays
nonplays1344893nonplays
onlays9398713o__nlays
ortolans846553ortolans
outbeams1236063outbeams
outblaze1996013outblaze
outblazes2085443outblazes
outbleats1144393outbleats
outbless1037963outbless
outbrags1136693outbrags
outbuys1246053out_buys
outcalls1038743outcalls
outdrags1046583outdrags
outdraws1236233outdraws
outeats72215703out_eats
outfalls1138143outfalls
outflank1544593outflank
outflanks1643233outflanks
outflies11310153outflies
outfloats1243573outfloats
outflows1445463outflows
outfly1238273outfl_y_
outgas7313203out_ga_s
outglare937383outglare
outglares1047003outglares
outgleams1242603outgleams
outglows1244933outglows
outgnaws12123893outgnaws
outhears11810393outhears
outlaid81110653out_laid
outlain71212613out_lain
outland81212343out_land
outlands988563out_lands
outlast71015443out_last
outlasts8108713out_lasts
outlaw9279643out_la_w
outleads9278763outleads
outleaps10237073outleaps
outlets73616363out_lets
outlies72421993out_lies
outmans92413283out_mans
outpace112613023outp_ace
outpaces122411943outpaces
outpity1237493outpity_
outplaced1446353outplaced
outplaying1645963outplaying
outplod10106343outpl_od
outplot9109483outpl_ot
outpolls1046213outpolls
outports1048273outports
outposts1037253outposts
outpours1036683outpours
outprayed1545763outprayed
outpress10118183outpress
outpulls1065443outpulls
outputs988493outp_uts
outreads9289003outreads
outroars838923outroars
outsay92611873out_say_
outsoars838853outsoars
outspans1038223outspans
outspeaks1554013outspeaks
outstay1047683outstay_
outtalks1236503outtalks
outwalks1535993outwalks
outwars10912793out_wars
outwears1197263outwears
overlays14239693overlays
overplays17287013overplays
plays106320773___plays
replays12399763_replays
routeways1543153routeways
splays114910873__splays
tutelars844993tutelars
unlays93810493_u_nlays
wordplays1852383wordplays

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621067.15620425.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.62523434.9
 
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.