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

105 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
outstays115662(None) 
outsays102710401outs_ays
outstay1047681outstay_
outlays102610902out_lays
outplays13246842outplays
outprays13236932outprays
outsay92611872outs_ay_
outsoars838852outsoars
outspans1038222outspans
outstand938042outstand
outstands1045542outstands
outstare81410692outstare
outstares91610182outstares
outstart81611282outstart
outstarts9176322outstarts
outstate81411992outstate
outstates91710752outstates
outstayed13185932outstayed
bobstays1543343bobstays
buttals938503but_tals
cuestas957933cuesta_s
cutaways1643813cutaways
eustasy1043873eu_stasy
forestays1546623forestays
homestays1744713homestays
ottars64112223o_t_tars
ousters74122793ou_sters
ousts55225703ou_st__s
outbeams1236063outbeams
outbrags1136693outbrags
outbuys1246053out_buys
outclass1037203outclass
outdates93114743outdates
outdrags1046583outdrags
outdraws1236233outdraws
outeats72215703out_eats
outgas7313203out_ga_s
outgnaws12123893outgnaws
outhears11810393outhears
outlaws10249603out_laws
outlay92711793out_lay_
outleads9278763outleads
outleaps10237073outleaps
outmans92413283out_mans
outpass939713out_pass
outplans10259533outplans
outplay12267723outplay_
outpray12268083outpray_
outrates82421373outrates
outreads9289003outreads
outroars838923outroars
outsaid81210923outs_aid
outsail71411413outs_ail
outsails8139863outsails
outsang83411273outs_ang
outsat62920283outs_a_t
outsaw92610283outs_a_w
outsees72616433outs_ees
outsells888643outsells
outserts8309803outserts
outsets73514923outs_ets
outshame1346743outshame
outshames1445923outshames
outsides92513233outsides
outsings93410333outsings
outsins73417863outs_ins
outsits73215253outs_its
outsizes172311083outsizes
outskate12168013outskate
outskates13177153outskates
outsmart10168923outsmart
outsmarts11155143outsmarts
outsoar739493outsoa_r
outsoles8813113outsoles
outspan938743outspa_n
outspeaks1554013outspeaks
outstared10188423outstared
outstated10169813outstated
outstaying1446093outstaying
outsteer837553outsteer
outsteers936033outsteers
outstood945933outstood
outstrip1045083outstrip
outstrips1145203outstrips
outstudy1242923outstudy
outstunt847223outstunt
outstunts943613outstunts
outsulks1244993outsulks
outswam1246613outswa_m
outsware11168843outsware
outswears1244303outswears
outswims1344393outswims
outtake11310793out_take
outtakes12310033out_takes
outtalk1138233out_talk
outtalks1236503out_talks
outtask1137053out_task
outtasks1235633out_tasks
outwars10912793out_wars
outwears1197263outwears
overstays1535943overstays
routeways1543153routeways
stays86022023___stays
suttas63813793sut_ta_s
unsays9399543_uns_ays

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.420425454.8
2DLD Change Limit1461621057.14020470.9
3Display Results1051050.0502100.0
 (SQL Overall)1786911057.61023481.1
 
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.