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

118 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
outcaste1011961(None) 
outcast91013741outcast_
outcastes11118901outcastes
outcasts10108681outcasts
outwaste11147941outwaste
nutcase975762nutcas_e
outate62923402out_a_te
outdate83016422outda_te
outfast101412122outfast_
outfasted13147172outfasted
outfasts11117232outfasts
outlast71015442outlast_
outlasted10128352outlasted
outlasts8108712outlasts
outmaster1147302outmaster
outrate72323182outra_te
outwasted13137682outwasted
outwastes12127692outwastes
subcaste1287852subcaste
caste75932363___caste
furcate12310453furca_te
guttate8328903gutta_te
mutase82811993mut_as_e
mutate83017483mut_a_te
nutate63017373nut_a_te
nutcases1085793nutcases
oatcake1345363oatca_ke
offcast1544473offcast_
offcasts1643013offcasts
outact8317203out_act_
outacted1139383out_acted
outacts9310213out_acts
outage72017533out_a_ge
outask1039103out_as_k
outasked1337123out_asked
outasks1138173out_asks
outbake13310773outba_ke
outboast1048543outboast_
outboasted1344343outboasted
outboasts1144763outboasts
outcall9310123outca_ll
outcalls1038743outcalls
outcaper1246873outcaper
outcatch1544293outcatch
outcavil1343833outcavil
outcharge1544813outcharge
outchide1447213outchide
outcity1238453outc_ity
outclass1037203outclas_s
outclassed13124543outclassed
outclasses12145133outclasses
outcome11310573outc_ome
outcurse1045833outcurse
outcurve1344433outcurve
outdance11238733outdance
outdare83113403outda_re
outdated1012513193outda_ted
outdates93114743outda_tes
outeat62824533outea_t_
outeaten8310423outea_ten
outeats72215703outea_ts
outfable1378813outfable
outface123011973outfa_ce
outfeast11107503outfeast_
outfeasted1444313outfeasted
outfeasts12114333outfeasts
outgas7313203outgas__
outgassed1145623outgassed
outgasses1036663outgasses
outgave11259563outga_ve
outgaze17239223outga_ze
outhustle1253053outhustle
outmasters1245733outmasters
outmost9511213outmost_
outpace112613023outpa_ce
outpass939713outpas_s
outpassed1245803outpassed
outpasses1146613outpasses
outpost9612443outpost_
outposts1037253outposts
outquote1775293outquote
outrace92418553outra_ce
outrage82616893outra_ge
outraise8311933outraise
outrance102212773outrance
outrange92410223outrange
outrated92219313outra_ted
outrates82421373outra_tes
outrave102614413outra_ve
outsat62920283outsa_t_
outsee63121803out__see
outset64027453out__set
outskate12168013outskate
outstate81411993outstate
outtake11310793outta_ke
outtask1137053outtas_k
outtasked1445373outtasked
outtasks1235633outtasks
outvalue1144233outvalue
outvote1038803out_vote
outwait10411763outwait_
outwaited13137293outwaited
outwaits1137493outwaits
outwash13187613outwas_h
outwashes15116183outwashes
outwrite1139453outwrite
outwrote1137723outwrote
posthaste1456603posthaste
retaste72313133ret_aste
subcastes1387493subcastes
suitcase1043893suitcas_e
sulcate9314423sulca_te
taste55127233__t_aste
uncase83817433_uncas_e
uncast84215713_uncast_
unchaste1346923_unchaste
upcast102710093_upcast_
upcasts11185643_upcasts

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 Limit1461621187.12620511.1
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.59223536.7
 
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.