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

174 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
statists831016(None) 
statisms1039541statisms
statist7317721statist_
atavists1137582atavists
etatisms1038292etatisms
etatist7415032etatist_
sadists83310852s_adists
satanists948232satanists
sitarists949372sitarists
statices102712342statices
statics93314532stati_cs
statins73719772stati_ns
stations82415222stations
statism9412282statis_m
statistic1147142statistic
statistics1244342statistics
statives112710792statives
statuses8409542statuses
stylists11207022stylists
tanists7313652_tanists
tsarists857302tsarists
abatises10311013abatises
agists75713173__agists
artists74215593_artists
astatines9310343astatines
atavisms1346993atavisms
atavist10311093atavist_
atheists1138713atheists
atomists102610963atomists
attaints846493attaints
attests7278813at_tests
autists73814853_autists
baptists1236723baptists
batiste939743_batiste
batistes1039713_batistes
botanists1148203botanists
chartists14126803chartists
chutists1335583chutists
cladists1136723cladists
cultists10107633cultists
czarists1966223czarists
dentists939263dentists
dialists9411413dialists
diarists9410363diarists
dualists958243dualists
egotists937063egotists
elitists848543elitists
escapists1344253escapists
essayists1242743essayists
etatism9610293etatis_m
fatalists12310023fatalists
flautists1253683flautists
flutists11256413flutists
gestaltists1252423gestaltists
imagists1175113imagists
latests73910313_latests
leftists11235513leftists
lutanists966843lutanists
lutists73810273_lutists
maists85817573_ma_ists
metalists11412663metalists
onanists838413onanists
oralists8611803oralists
otitises839163otitises
papists112110453_papists
pianists1049013pianists
pietists1038323pietists
protists10313363protists
racists92613323_racists
rapists92510753_rapists
realists83014843realists
sacrists1039563sacrists
sadisms10359113s_adisms
sadist74221353s_adist_
saints65122423s_a_ints
satanisms1148143satanisms
satanist8313363satanist_
satiate7315403s_atiate
satiates8314633s_atiates
satiety1038203s_atiety
satinets8311733s_atinets
satins64930483s_ati_ns
satires72617573s_atires
satirists958923satirists
satis55633683s_ati__s
satisfy1344183s_atisfy
scatts85914663scat__ts
schists1248543s_chists
sealifts1135473sealifts
seatings93614303seatings
semitists1148183semitists
sexists14267673s_exists
shists96515113s__hists
shitlists1245533shitlists
sitarist8315283sitarist_
skatings13326993skatings
slatiest82616263slatiest_
slatings94011723slatings
sodalists1038153sodalists
soloists869153soloists
sophists1347293sophists
spaits85017473spa_i_ts
stabiles10311403stabiles
stadias8411113stadi_as
stadiums1145703stadiums
stagiest91613403stagiest_
stagings10378343stagings
staigs75414813sta_i_gs
stains64923653sta_i_ns
stairs65416333sta_i_rs
staithes1138953staithes
stalest73720173stalest_
staminas1048853staminas
stanines85115673stanines
stardusts1043153stardusts
starets73515923sta_rets
starlets81610083starlets
starts65423123sta__rts
stases64225563sta__ses
stasis63116873sta__sis
statant7313123statant_
staters73922343stat_ers
states64337083stat__es
static83118683stati__c
statical1039423statical
statice92614033stati_ce
staticky1743233staticky
statin63921473stati__n
stating83725163stati_ng
station72717243stati_on
stative102612933stati_ve
statocysts1552723statocysts
stators73915583stat_ors
stats55933363sta___ts
statues74614903stat_ues
statures83711113statures
status65515213stat__us
statusy10455423status_y
statute7419323stat_ute
statutes8368893statutes
steatite8310583steati_te
steatites939843steatites
stigmatists1453043stigmatists
stilts67915313s__tilts
stints65119763s__tints
stockists15194563stockists
stotins73213873stoti_ns
stotts64612863stot__ts
straits74916323strai_ts
strategists1252883strategists
stylises11188943stylises
stylist102110283stylist_
subsists1037993subsists
subtests1037533subtests
sumoists1046733sumoists
tachists1348183_tachists
taints64520533_ta_ints
tamises92715973_tamises
tanist6324593_tanist_
tapises92914013_tapises
theists1039153_theists
titlists837293_titlists
totalists9310753totalists
tsarisms1056653tsarisms
tsarist7712253tsarist_
tubists9288323_tubists
twists9549753_t_wists
typists1236173_typists
tzarists1755693tzarists
utopists1045773utopists
vitalists1239223vitalists
votarists1298603votarists
waists97415453_wa_ists
whatsits1443543whatsits

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621747.68619016.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911748.17221866.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.