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

166 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
posttest1041023(None) 
posttests1144971posttests
coattest1038862coattest
hottest10411382ho_ttest
mostest9314792mos_test
pastiest103319542pastiest
pestiest103018412pestiest
phattest1336912phattest
politest10312942politest
poshest12312422pos_hest
postheat13411242postheat
posties93128812posties_
postteen1055692postteen
pottiest102815972pottiest
poutiest103016792poutiest
apostates1149163apostates_
apostles1037753apostles_
attest62618613__attest
boskiest14289733boskiest
bossiest103112213bossiest
bustiest102815053bustiest
coattests1143463coattests
contest93523233co_ntest
cosiest93819853cos_iest
costless10310003costless
costliest1138563costliest
couthest13312083couthest
dotiest83717453do_tiest
dottiest92611393dottiest
dustiest93015073dustiest
fastest102413723fas_test
fattest102913063_fattest
fittest102510803_fittest
flattest1138713flattest
footiest113514913footiest
footrest11308853footrest
frostiest1239213frostiest
fustiest113014573fustiest
ghostiest1336543ghostiest
goutiest93013883goutiest
gustiest92914523gustiest
hastiest112916493hastiest
hootiest113115643hootiest
hostess103210243hos_tess
joltiest15249403joltiest
jostles143411143jostles_
justest1449893jus_test
loftiest1139083loftiest
lostness837683lostness
lottes65322753lo_ttes_
lustiest82914493lustiest
mistiest103018313mistiest
moistest1038763moistest
mossiest103112443mossiest
mostests1036833mos_tests
mottes85523693mo_ttes_
mustiest103017533mustiest
nastiest83615953nastiest
nosiest73415673nos_iest
obtest81213013_o_btest
oftest91212003_o_ftest
pastes85233913pas_tes_
pasties94529813pasties_
pastless102411203pastless
pastness102510503pastness
peartest10311303peartest
peatiest103118803peatiest
pertest9317043p_ertest
peskiest142610163peskiest
pestles93217693pestles_
pettiest103113963pettiest
pistes85325633pis_tes_
platiest103216083platiest
plottiest11287833plottiest
pockiest163412053pockiest
podgiest12269093podgiest
podites103014733podites_
poetess938933po_etess
poetless1038723poetless
pointes93216753pointes_
pointiest1139623pointiest
pokiest133314913po_kiest
pontes83627853po_ntes_
poorest9312773po_orest
porkiest143513713porkiest
porniest103214313porniest
portent93619643po_rtent
portless10310643portless
portliest11310183portliest
portress1038323portress
poses74642763pos__es_
poshness1356653poshness
posies84431433pos_ies_
posited10511493posite_d
positivest1544903positivest
posits85718713posit_s_
posoles9314883posoles_
posses85128803pos_ses_
possess9419123pos_sess
posset84923253pos_se_t
possets94212773possets_
postages112815323postages_
postals93716373postals_
postarrest1244643postarrest
postbase1246443postbase
postdates1248863postdates_
posted93722493pos_te_d
posteen93512623pos_teen
posteens10309733posteens
poster84129173pos_te_r
postern93615613pos_tern
posters93928013pos_ters
posthaste1456603posthaste
postheats1447433postheats
postie84123963postie__
postins93721203postins_
postmen113110423postme_n
postops11311713postops_
postpose1247653postpose
postriot10412253postriot
posts75228783pos_t_s_
posttax1645533postt_ax
postteens1144373postteens
postures10313783postures_
posturist11410443posturist
potent84223353po__tent
potsies93019483potsies_
potted94624013po_tte_d
potteen9319673po_tteen
potter83926983po_tte_r
potters94024343po_tters
pottery123011073po_ttery
potties93723543potties_
pottles93816983pottles_
pottos84615873po_ttos_
poxiest163412253po_xiest
pretest9517633p_retest
prettiest1199803prettiest
proettes10312763proettes_
promptest1546063promptest
prosiest10416523pros_iest
prostates11314423prostates_
prosties101421193prosties_
protest9317533p_rotest
purtiest102414113purtiest
pushiest133211713pushiest
pussiest102911753pussiest
rootiest83115593rootiest
rosettes8310343rosettes_
rosiest73919213ros_iest
rottes64524833ro_ttes_
rustiest83116803rustiest
softest10310603so_ftest
soothest113312243soothest
sootiest84016753sootiest
sportiest111711023sportiest
spottiest11177683spottiest
tastiest83216633tastiest
testiest82715223testiest
toastiest937423toastiest
vastest102911513vas_test
vastiest112713073vastiest
wattest102412153_wattest
wettest10239363_wettest
zestiest173011103zestiest
zootiest173311213zootiest

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.403443402.0
2DLD Change Limit1461621667.29620033.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.76223021.3
 
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.