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

129 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
outstates9171075(None) 
outskates13177151outskates
outstares91610181outstares
outstate81411991outstate_
outstated10169811outstated
outdates93114742out_dates
outrates82421372out_rates
outshames1445922outshames
outskate12168012outskate_
outskated14176832outskated
outstands1045542outstands
outstare81410692outstare_
outstared10188422outstared
outstarted1155072outstarted
outstarts9176322outstarts
outstayed13185932outstayed
outstays1156622outsta_ys
outtakes12310032out_takes
substates111410332substates
unstates81314992_unstates
upstates10189642_upstates
apostates1149163apostates
automates11412053automates
butylates1444713butylates
butyrates1446083butyrates
cuttages11297223cut_tages
downstates1444343downstates
estates74520183__estates
gestates93213733_gestates
guttate8328903gut_tate_
guttated10266873gut_tated
instates81615833_instates
intestates10159433intestates
lustrates939463lustrates
misstates11710633misstates
mutates92215793mu__tates
mutilates11310953mutilates
nutates73214973nu__tates
obturates1157003obturates
octettes1045533octet_tes
offstages1652033offstages
ostomates1149343ostomates
ouistitis943083ouistitis
outages82317323ou__tages
outate62923403ou__tate_
outbakes1439993out_bakes
outblazes2085443outblazes
outbraves1436713outbraves
outcastes11118903outcastes
outdares92712463out_dares
outdate83016423out_date_
outdated1012513193out_dated
outdebates1342833outdebates
outeaten8310423out_eaten
outeats72215703out_eat_s
outfaces132311393out_faces
outgazes18248713out_gazes
outglares1047003outglares
outpaces122411943out_paces
outplaces1347743outplaces
outquotes1874513outquotes
outraces102217863out_races
outrages92215933out_rages
outrate72323183out_rate_
outrated92219313out_rated
outraves112313833out_raves
outsails8139863outs_ails
outsat62920283outs_at__
outsays102710403outs_a_ys
outscores11178463outscores
outsees72616433outs__ees
outserts8309803outsert_s
outserves12147373outserves
outsets73514923outs_et_s
outshame1346743outshame_
outshamed1545313outshamed
outshines1238613outshines
outsides92513233outs_ides
outsits73215253outs_it_s
outsizes172311083outs_izes
outsmarted1344323outsmarted
outsmarts11155143outsmarts
outsmiles1146443outsmiles
outsmokes1545313outsmokes
outsnores9176773outsnores
outsoared10157593outsoared
outsoars838853outsoa_rs
outsoles8813113outs_oles
outspans1038223outspa_ns
outstand938043outsta_nd
outstart81611283outsta_rt
outstating1139363outstating
outstation1046163outstation
outstations1145343outstations
outstay1047683outsta__y
outsteer837553outst_eer
outsteers936033outsteers
outstrides1154743outstrides
outstrips1145203outstrips
outstrives1374253outstrives
outstrokes1464583outstrokes
outstudies1142663outstudies
outstunted1143183outstunted
outstunts943613outstunts
outsware11168843outsware_
outtake11310793out_take_
outtalks1236503out_talks
outtasks1235633out_tasks
outtrades1077693outtrades
outvotes1137903out_votes
outwastes12127693outwastes
outwrites1238233outwrites
overstates131110113overstates
prostates11314423prostates
pulsates1048813puls_ates
restates83423433_restates
states64337083___states
substages12127353substages
substate101711093substate_
substrates12168553substrates
testates83615453_testates
tungstates1142683tungstates
unstate71916213_unstate_
unstated91615813_unstated
upstages11147373_upstages
upstares10178583_upstares
upstate91610493_upstate_
upstater10156663_upstater
upstaters11174803_upstaters

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.406440125.6
2DLD Change Limit1486411297.21620598.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.68523251.9
 
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.