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

128 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
outprays1323693(None) 
outplays13246841outplays
outpray12268081outpray_
outbrags1136692outbrags
outdrags1046582outdrags
outdraws1236232outdraws
outlays102610902out_lays
outpass939712outp_ass
outplans10259532outplans
outplay12267722outplay_
outprayed1545752outprayed
outpress10118182outpress
outsays102710402out_says
outstays1156622outstays
betrays12127823bet_rays
butyrals1344503butyrals
cutaways1643813cutaways
cutgrass1144343cutgrass
estrays10529403est_rays
gunplays1442713gunplays
hurrays13386153hu_rrays
koupreys1741733kou_preys
nutgrass943933nutgrass
orfrays1343533o_rfrays
ospreys1233143o_spreys
outbarks1437833outbarks
outbeams1236063outbeams
outbrag1036993outbra_g
outbrave1357133outbrave
outbraves1436713outbraves
outbrawl1344823outbrawl
outbrawls1443483outbrawls
outbreaks1544073outbreaks
outbuys1246053out_buys
outclass1037203outclass
outcrawl1344583outcrawl
outcrawls1443513outcrawls
outcries10313573outcries
outcrops1246853outcrops
outcross1036823outcross
outcrows1346653outcrows
outcry1137993outcr_y_
outdares92712463outdares
outdrag937003outdra_g
outdrank1345433outdrank
outdraw1136903outdra_w
outdrawn1245013outdrawn
outdreams1243553outdreams
outdress9137323outdress
outdrops1136543outdrops
outearns838403outearns
outeats72215703out_eats
outers64230173outer__s
outgas7313203out_ga_s
outgnaws12123893outgnaws
outgrins979823outgrins
outgross936423outgross
outgrows1236283outgrows
outhears11810393outhears
outlaws10249603out_laws
outlay92711793out_lay_
outleads9278763outleads
outleaps10237073outleaps
outmans92413283out_mans
outpace112613023outp_ace
outpaces122411943outpaces
outpity1237493outpity_
outplace1257913outplace
outplaces1347743outplaces
outplan9249443outpla_n
outplayed1545213outplayed
outplods11105613outplods
outplots1086363outplots
outpolls1046213outpolls
outports1048273outports
outposts1037253outposts
outpours1036683outpours
outpraying1646523outpraying
outpreach1642703outpreach
outpreen1046913outpreen
outpreens1144603outpreens
outprice1238273outprice
outprices1337623outprices
outpulls1065443outpulls
outputs988493outp_uts
outrace92418553out_race
outraces102217863out_races
outrage82616893out_rage
outrages92215933out_rages
outraise8311933out_raise
outran63218893out_ra_n
outrang83813953out_rang
outrank112611973out_rank
outranks12298823out_ranks
outrate72323183out_rate
outrates82421373out_rates
outrave102614413out_rave
outraves112313833out_raves
outreads9289003outreads
outrigs82811263out_rigs
outroars838923outroars
outrows10311403out_rows
outruns72911543out_runs
outsay92611873out_say_
outsoars838853outsoars
outspans1038223outspans
outspeaks1554013outspeaks
outsprang1243903outsprang
outspreads1342753outspreads
outstay1047683outstay_
outtrade938343outtrade
outtrades1077693outtrades
outtrots838373outtrots
outwards1299123outwards
outwars10912793out_wars
outwears1197263outwears
overpays16248253overpays
portrays1345293port_rays
prays105022433___prays
resprays1344713resprays
routeways1543153routeways
sprays115913643__sprays
strays96417933_st_rays
sunrays1037083su_nrays
sutras64818593sut_ra_s
trays85623433__t_rays
vouvrays1741373vou_vrays
whiprays1942503whiprays

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621286.37622923.8
3Display Results1281280.0632031.7
 (SQL Overall)1786911286.90525878.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.