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

183 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
posteens1030973(None) 
posteen93512621posteen_
posterns102713721posterns
postteens1144371postteens
poteens92910881po_teens
potteens10256791potteens
pasterns104112622pasterns
postern93615612postern_
posters93928012post_ers
posties93128812postie_s
postins93721202post_ins
postmen113110422postmen_
postteen1055692postteen_
poteen83514262po_teen_
potheens13266482potheens
potteen9319672potteen_
preteens1038122preteens
apostles1037753apostle_s
bootees94114473bootee_s
boreens9310403bo_reens
bostons9312903bost_ons
canteens1038573canteens
cisterns10369573cisterns
coatees93816553coatee_s
colleens1036843colleens
contemns1237403contemns
costers94128333cost_ers
costless10310003costless
costrels1038933costrels
cysteins1355733cysteins
dasheens1244693dasheens
esteems935243_esteems
fastens105511753fast_ens
fifteens1442753fifteens
fosterers12238023fosterers
fosters104220103fost_ers
fourteens1243343fourteens
goatees82710443goatee_s
gombeens1342703gombeens
hastens106214813hast_ens
holsteins1245263holsteins
hostelers1246633hostelers
hostels103712313host_els
hostess103210243host_ess
hostlers113310483hostlers
jostlers15357683jostlers
jostles143411143jostle_s
lateens74210553_lateens
listees73416673listee_s
listens74014133list_ens
lostness837683lostness
mestees94617753mestee_s
moistens10268773moist_ens
moreens939963mo_reens
mostests1036833mostests
mustees94614923mustee_s
osseins736133_osseins
ostlers72911203_ostlers
pastels95215183past_els
pastern94415063pastern_
pasters94531733past_ers
pastes85233913past_e_s
pasteups1243493pasteups
pasties94529813pastie_s
pastless102411203pastless
pastness102510503pastness
patens84820863p_at_ens
pattens95414923p_attens
patterns10439943patterns
pectens11189203pect_ens
peebeens1243063peebeens
peens76428193p___eens
pentenes10315633pentenes
pesterers112510453pesterers
pesters93827093pest_ers
pestles93217693pestle_s
phosgenes1544763phosgenes
pistareens1243153pistareens
pistes85325633pist_e_s
pistons93016373pist_ons
platens94213983plat_ens
pocosens1255253pocosens
poetess938933poet_ess
poetless1038723poetless
poitrels1035243poitrels
poleyns1236113po_leyns
pollees93215333pollee_s
pollens93713303po_llens
polyenes13510063polyenes
pongees104212543pongee_s
pontes83627853pont_e_s
pontons93315553pont_ons
pontoons10279313pontoons
portend103411193port_end
portends11358963portends
portent93619643port_ent
portents103512823portents
porteress1137933porteress
porters93722703port_ers
portions10514413portions
portless10310643portless
portress1038323portress
posers84223973pos__ers
poses74642763pos__e_s
poseurs9378293pos_eurs
poshness1356653poshness
posies84431433pos_ie_s
positions11811503positions
positrons1186543positrons
posoles9314883posole_s
posses85128803pos_se_s
possess9419123pos_sess
possets94212773pos_sets
postages112815323postages
postals93716373post_als
postbags1345293postbags
postboys1585273postboys
postdocs1345273postdocs
posted93722493post_e_d
poster84129173post_e_r
postheat13411243postheat
postheats1447433postheats
postie84123963postie__
postin83521033post_in_
posting105622243post_ing
postings112912303postings
postman112410043postman_
postops11311713post_ops
postpone1248693postpone
postpones1348833postpones
postpunk1642303postpunk
posts75228783post___s
postsync1542143postsync
postsyncs1651933postsyncs
posttest10410233posttest
posttests1144973posttests
posturers1137053posturers
postures10313783postures
potent84223353po_t_ent
potheen12257893potheen_
pothers123818623po_thers
potions93417423po_tions
potmen102713093po_tmen_
potsies93019483potsie_s
potstones1149213potstones
potterers11218663potterers
potters94024343po_tters
potties93723543pottie_s
pottles93816983pottle_s
potzers184010543po_tzers
pouters94221873pout_ers
poutines102415103poutines
powters124015663powt_ers
preens85020113p__reens
preteen939873preteen_
prosties101421193prostie_s
proteans102811543proteans
proteins102114283proteins
puttees93612913puttee_s
ratteens8256053ratteens
rontgens944683rontgens
rosters73727543rost_ers
sateens73710753_sateens
sheens95116993__sheens
sixteens1542943sixteens
skeens103912913__skeens
softens10347623soft_ens
steeds73814883__steeds
steeks103613703__steeks
steels64117983__steels
steeps85215193__steeps
steers63820983__steers
steins64818343__steins
sterns64616763__sterns
subteens1037423subteens
teens56227483___teens
testees74215913testee_s
unsteels845793unsteels
vestees103513173vestee_s
westerns11328963westerns
yestreens1243533yestreens
youthens1435383youthens
zosters163015413zost_ers

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.423422437.4
2DLD Change Limit1461621837.22020244.0
3Display Results1831830.0762407.9
 (SQL Overall)1786911837.71923149.5
 
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.