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

330 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
tipsters1027850(None) 
hipsters13268781hipsters
tapsters10318801tapsters
tipster9299051tipster_
bisters93922602bi_sters
diasters92913172diasters
diesters92513592diesters
fibsters13126402fibsters
gypsters1434022gypsters
hipster12288782hipster_
kiesters123310142kiesters
listers74026522li_sters
minsters103813912minsters
misters93927502mi_sters
piasters102912802piasters
quipsters2043592quipsters
sisters73721572si_sters
tapster9299272tapster_
tasters74225642t_asters
testers74124542t_esters
thirsters1235222thirsters
tilters73315932ti_lters
tinters74221102ti_nters
tippers113414342tip_pers
tipplers12336352tipplers
tipsier9268892tipsier_
titers64526402ti__ters
titters74219612ti_tters
toasters83912702toasters
trusters83112242trusters
trysters11298362trysters
twisters11268172twisters
asters65631603__asters
attesters935803attesters
basters94930303_basters
bilsteds1134273bilsteds
bimesters1336323bimesters
bister84922763bi_ster_
bistres94017213bi_stres
biters83925233bi__ters
bitters94920353bi_tters
blasters104116143blasters
blisters104015083blisters
blusters104413883blusters
boasters103915653boasters
bolsters103712443bolsters
boosters104013433boosters
bursters1038983bursters
busters94724123_busters
casters94729893_casters
ciphers14379983cip_hers
cistern93310693ci_stern
cisterns10369563ci_sterns
citers85022973ci__ters
clusters102912393clusters
clysters13227823clysters
coasters104317303coasters
copters113621273cop_ters
costers94128303_costers
dabsters1137053dabsters
dempsters1435273dempsters
diastems11226523diastems
diaster82813313diaster_
diester83013683diester_
dieters83216423di_eters
digesters11257873digesters
dilaters92513053dilaters
diluters9288103diluters
dimeters11411083dimeters
diopters1137683diopters
dippers123615173dip_pers
diptera1037203dip_tera
disasters1039143disasters
disputers1236603disputers
dopesters1237283dopesters
dumpsters1453743dumpsters
dusters84918353_dusters
easters75125683_easters
epistlers1154113epistlers
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibster12146533fibster_
fighters15269393fighters
filisters1236993filisters
filters103816543fi_lters
fishers134714723fi_shers
fitters104517743fi_tters
flusters113811493flusters
fosters104220093_fosters
gagsters10317073gagsters
gasters85624283_gasters
gippers123212073gip_pers
gipsies1039903gipsie_s
glisters93912603glisters
gristers94013403gristers
gypster1333953gypster_
hamsters13710423hamsters
heisters113413133heisters
hinters103719573hi_nters
hipsterism1753573hipsterism
hissers104112313hi_ssers
hitters104717583hi_tters
hoisters113513473hoisters
holsters113211933holsters
hoopsters1445673hoopsters
imposters13347333imposters
imputers1235813imputers
instars7411113_instars
insteps936573_insteps
inters64328043_i_nters
issuers746123_issuers
jesters144118193_jesters
jilters144211953ji_lters
jitters144314463ji_tters
jousters153210403jousters
justers143815723_justers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiester11329973kiester_
kilters113813593ki_lters
kippers153211423kip_pers
kissers114211293ki_ssers
kiters105218583ki__ters
klisters123910483klisters
lamsters1099753lamsters
lapsers93911053laps_ers
lasters75627693_lasters
leisters83312823leisters
lifters104313773li_fters
lighters123111373lighters
limiters10249323limiters
linters73822613li_nters
lippers113416433lip_pers
lispers94514323li_spers
listees73416673li_stees
listels74212433li_stels
listens74014133li_stens
lister64527253li_ster_
liters65429873li__ters
litters73422563li_tters
lobsters10268733lobsters
lusters73921433_lusters
masters94628923_masters
meisters103313843meisters
milters93619083mi_lters
ministers1139613ministers
minster93914323minster_
minters93822463mi_nters
misers85025703mi_s_ers
missteers1135913missteers
missteps12156143missteps
mister84728563mi_ster_
misterm114314513mi_sterm
misterms123711333mi_sterms
miters84328773mi__ters
mobsters12359053mobsters
monsters103314533monsters
munsters104010543munsters
musters94522493_musters
nesters74422783_nesters
nippers113012613nip_pers
niters64624203ni__ters
oldsters996733oldsters
ousters74122773_ousters
oysters103411683_oysters
pasters94531733_pasters
paters84935823__paters
pensters103012123pensters
pesters93827093_pesters
peters86624593__peters
piaster93012883piaster_
piastres10249303piastres
pilasters1138213pilasters
pilsners1035533pilsners
pinasters1136813pinasters
pipers104318663pip__ers
pipestems1542833pipestems
pishers123815753pi_shers
pissers95014753pi_ssers
pistes85325633pi_ste_s
plasters103518133plasters
posters93927993_posters
presters103419003presters
punsters103310583punsters
questers17168763questers
quipster1933933quipster_
rasters74629023_rasters
resters74130403_resters
righters122610703righters
rimesters1137473rimesters
rinsers73815743rins_ers
rioters73615503ri_oters
ripeners1036833ripeners
ripostes10239083riposte_s
rippers114115023rip_pers
ripplers12337113ripplers
ripstops1265013ripstops
risers64624783ri_s_ers
riskers114011993ri_skers
ritters74020613ri_tters
riveters11228153riveters
roasters83615913roasters
roisters83615543roisters
roosters83514653roosters
rosters73727533_rosters
rousters84315653rousters
roysters113610523roysters
shysters14106433shysters
sifters103714783si_fters
sighters122510593sighters
sinters74024073si_nters
sippers113117743sip_pers
sister64421583si_ster_
sitters74221543si_tters
spinsters1136603spinsters
spitters104113383spitters
stinters83312743sti_nters
stipites1039653stipite_s
stipplers1334433stipplers
taperers10269773taperers
tapers84025813tap__ers
tappers113416543tap_pers
tarsiers8298533tarsiers
taster64930573t_aster_
tastes64126423t_aste_s
taters64932193t__aters
tatters74520483t_atters
taunters8259263taunters
teamsters1135973teamsters
teasers75317243teas_ers
teeters74018303t_eeters
tempters12257293tempters
tenters73921103t_enters
testees74215913t_estees
tester64227153t_ester_
testes65125823t_este_s
tetters74320473t_etters
theaters114211893theaters
thirster1135673thirster_
thrusters1245313thrusters
tickers133617723ti_ckers
ticklers14339303ticklers
tiddlers10288653tiddlers
tidiers8389773ti_diers
tiers55526523ti___ers
tigers75616503ti__gers
tightens12297943tightens
tighter112910683tighter_
tilers63523493ti__lers
tillers73418733ti_llers
tilter63417693ti_lter_
timbers113111833ti_mbers
timers84420993ti__mers
tinders84219173ti_nders
tinglers93710573tinglers
tinkers113517143ti_nkers
tinklers12298183tinklers
tinners73717303ti_nners
tinsels738373tins_els
tinter63923643ti_nter_
tipless92610063tip_less
tipper103918413tip_per_
tippets11339373tip_pets
tippier113210543tippier_
tippler11348343tippler_
tipples112811253tipple_s
tipsheet1345833tipsheet
tipsheets1442223tipsheets
tipsiest10228953tipsiest
tipsiness1135703tipsiness
tipstaff1642993tipstaff
tipstaffs1751773tipstaffs
tipstaves1443343tipstaves
tipstock1643733tipstock
tipstocks1743423tipstocks
tiptoes939173tip_toes
tiptops1136073tip_tops
tissues737463tissue_s
titer55430613ti__ter_
titfers10318933ti_tfers
tithers104216733ti_thers
titres64718933ti__tres
titter63421163ti_tter_
toaster74414463toaster_
tooters73818773t_ooters
topers85025323top__ers
toppers113914603top_pers
topsiders1243013topsiders
tossers74713493t_ossers
toters65026363t__oters
totters74618733t_otters
touters74018333t_outers
trashers113013623trashers
treaters83615823treaters
tricksters16264763tricksters
trimesters1245413trimesters
trimeters1139203trimeters
trippers123210153trip_pers
trotters83310233trotters
trussers8348263trussers
trustees8339323trustees
truster73114313truster_
trustors8268893trustors
tryster10369513tryster_
trystes10419993tryste_s
tufters10298343t_ufters
tuskers113710033t_uskers
tussers74313563t_ussers
tweeters11287143tweeters
twister10308953twister_
twitters11296773twitters
ulsters72711983_ulsters
upsteps1133743_upsteps
upstirs935293_upstirs
vipers114914533vip__ers
visiters1137403visiters
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
winters103720473wi_nters
wipers115416083wip__ers
wishers133215213wi_shers
wresters112711733wresters
xysters17307163_xysters
zesters163517293_zesters
zippers203310373zip_pers
zosters163015403_zosters

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.1731032896.0
2DLD Change Limit1461623307.70318974.7
3Display Results3303300.1232682.9
 (SQL Overall)1786913307.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.