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

85 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
outskates1317715(None) 
outskate12168011outskate_
outskated14176831outskated
outstates91710751outstates
outdates93114742out_dates
outrates82421372out_rates
outshames1445922outshames
outstares91610182outstares
outstate81411992outstate_
outstated10169812outstated
automates11412053automates
butylates1444713butylates
butyrates1446083butyrates
lustrates939463lustrates
mutates92215793mut__ates
mutilates11310953mutilates
nutates73214973nut__ates
obturates1157003obturates
ostomates1149343ostomates
outages82317323out__ages
outate62923403out__ate_
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
outskating1536853outskating
outskirts1343513outskirts
outsmarted1344323outsmarted
outsmarts11155143outsmarts
outsmiles1146443outsmiles
outsmokes1545313outsmokes
outsnores9176773outsnores
outsoared10157593outsoared
outsoars838853outsoa_rs
outsoles8813113outs_oles
outspans1038223outspa_ns
outstands1045543outstands
outstare81410693outstare_
outstared10188423outstared
outstarted1155073outstarted
outstarts9176323outstarts
outstayed13185933outstayed
outstays1156623outsta_ys
outsware11168843outsware_
outtakes12310033out_takes
outtrades1077693outtrades
outvotes1137903out_votes
outwastes12127693outwastes
outwrites1238233outwrites
pulsates1048813puls_ates
skates104219403___skates
substates111410333substates
unstates81314993_unstates
upstates10189643_upstates

Search took 9 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.420425454.8
2DLD Change Limit148641857.83018983.5
3Display Results85850.0302833.3
 (SQL Overall)178691858.28021581.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.