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

411 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
twisters1126817(None) 
twister10308951twister_
twitters11296771twitters
bisters93922612_bisters
blisters104015082blisters
glisters93912602glisters
gristers94013402gristers
heisters113413132heisters
hoisters113513482hoisters
keisters123212042keisters
klisters123910482klisters
leisters83312822leisters
listers74026532_listers
meisters103313842meisters
misters93927512_misters
roisters83615552roisters
sisters73721592_sisters
swifters14277482swifters
swishers14328052swishers
tapsters10318802tapsters
tasters74225642t_asters
testers74124542t_esters
thirsters1235232thirsters
tilters73315952t_ilters
tinters74221112t_inters
tipsters10278512tipsters
titers64526412t_i_ters
titters74219622t_itters
toasters83912722toasters
trusters83112262trusters
trysters11298372trysters
tweeters11287142tweeters
twiers95410162twi__ers
twiners10459632twi_ners
twirlers11274302twirlers
twisted11277432twiste_d
twistier1134812twistier_
twists9549752twist__s
twitter10278092twitter_
twittery14303892twittery
waisters113811522waisters
wasters104026592_wasters
westers105221962_westers
winters103720482_winters
wishers133215212_wishers
assisters936353assisters
asters65631603__asters
attesters935803attesters
atwitter1143673atwitter_
awaiters1146643awaiters
baiters94619303bai_ters
banisters11189473banisters
basters94930303_basters
bister84922763_bister_
bistres94017213_bistres
biters83925243_bi_ters
bitters94920363_bitters
blasters104116143blasters
blister94415313blister_
blistery13418713blistery
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013443boosters
bursters1038983bursters
busters94724133_busters
canisters112310193canisters
casters94729903_casters
chitters133711173chitters
cistern93310703_cistern
cisterns10369573_cisterns
citers85022983_ci_ters
cloisters1137433cloisters
clusters102912403clusters
clysters13227843clysters
coasters104317333coasters
cointers103616413cointers
costers94128333_costers
crispers12309433crispers
critters103511323critters
dabsters1137053dabsters
demisters1249203demisters
diasters92913183diasters
diesters92513603diesters
dieters83216433_dieters
drifters12417913drifters
dusters84918363_dusters
easters75125683_easters
emitters10349643emitters
enlisters937113enlisters
epistlers1154113epistlers
esters64627733__esters
fainters11349693fainters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
filisters1237003filisters
filters103816553_filters
fishers134714723_fishers
fitters104517753_fitters
flirters11337933flirters
flitters114312173flitters
flusters113811503flusters
fosters104220103_fosters
friskers15337373friskers
fritters113810783fritters
gagsters10317083gagsters
gaiters83516543gai_ters
ganisters10248313ganisters
gasters85624293_gasters
glistens9366593glistens
glister84013343glister_
glitters93710543glitters
goiters84014443goi_ters
grifters12389233grifters
grister83915413grister_
gritters94210633gritters
gypsters1434023gypsters
hamsters13710423hamsters
heister103613623heister_
hinters103719583_hinters
hipsters13268793hipsters
hissers104112313_hissers
hitters104717593_hitters
hoister103714203hoister_
holsters113211943holsters
insisters997653insisters
inters64328053__inters
jesters144118193_jesters
jilters144211963_jilters
jitters144314473_jitters
jointers15289323jointers
jousters153210423jousters
justers143815733_justers
kaisers11369273kais_ers
keesters12319593keesters
keister113011573keister_
keysters15326333keysters
kiesters123310153kiesters
kilters113813603_kilters
kissers114211293_kissers
kiters105218593_ki_ters
klister113410643klister_
knitters12336623knitters
lamisters1157123lamisters
lamsters1099753lamsters
lasters75627693_lasters
leister73212753leister_
lifters104313783_lifters
linters73822633_linters
lispers94514323_lispers
listees73416673_listees
listels74212433_listels
listens74014133_listens
lister64527253_lister_
liters65429883_li_ters
litters73422573_litters
lobsters10268743lobsters
loiters74116613loi_ters
lusters73921443_lusters
magisters1235803magisters
masters94628923_masters
meister93114163meister_
milters93619093_milters
ministers1139623ministers
minsters103813923minsters
minters93822473_minters
misers85025703_mis_ers
mister84728563_mister_
misterm114314513_misterm
misterms123711353_misterms
miters84328783_mi_ters
mobsters12359063mobsters
moistens10268773moistens
moister94015373moister_
monsters103314543monsters
munsters104010553munsters
musters94522513_musters
nesters74422793_nesters
niters64624213_ni_ters
oldsters996733oldsters
omitters10277653omitters
ousters74122793_ousters
oysters103411693_oysters
painters103013023painters
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
philters1398173philters
piasters102912813piasters
pishers123815753_pishers
pissers95014753_pissers
pistes85325633_piste_s
plaisters1137813plaisters
plasters103518133plasters
pointers103013723pointers
poisers94214433pois_ers
posters93928013_posters
presters103419003presters
printers103214903printers
punsters103310583punsters
questers17168763questers
quieters17248733quieters
quilters17228433quilters
quipsters2043593quipsters
quitters17238523quitters
raisers73617393rais_ers
rasters74629023_rasters
registers1038893registers
reinters82614773reinters
resisters9310453resisters
resters74130403_resters
rioters73615513_rioters
risers64624783_ris_ers
riskers114011993_riskers
ritters74020623_ritters
roasters83615933roasters
roister73516203roister_
roosters83514663roosters
rosters73727543_rosters
rousters84315683rousters
roysters113610533roysters
seisers73816393seis_ers
shifters14319853shifters
shysters14106453shysters
sifters103714793_sifters
sinters74024083_sinters
sister64421583_sister_
sitters74221553_sitters
skirters12337243skirters
skitters12349553skitters
slitters84014133slitters
smiters93414363smi_ters
snifters11318613snifters
spinsters1136613spinsters
spitters104113383spitters
stinters83312753stinters
suiters73618883sui_ters
swashers14389533swashers
swatters113911793swatters
sweaters113811063sweaters
swelters113110193swelters
swifter13318053swifter_
swiggers13337123swiggers
swillers11299113swillers
swimmers15276693swimmers
swingers123710423swingers
swisher13369523swisher_
swishes133411373swishe_s
swisses10417143swisse_s
swithers144310533swithers
swotters11448483swotters
tailers73720183tai_lers
tapster9299273tapster_
tarsiers8298533tarsiers
taster64930573t_aster_
tastes64126423t_aste_s
taters64932203t__aters
tatters74520483t_atters
taunters8259273taunters
teamsters1135973teamsters
teasers75317243teas_ers
teeters74018303t_eeters
tempters12257293tempters
tenters73921103t_enters
testees74215913t_estees
tester64227153t_ester_
testes65125823t_este_s
tetters74320473t_etters
theaters114211903theaters
thinkers15308703thinkers
thinners11327753thinners
thirster1135673thirster_
thistles1198233thistles
thrusters1245333thrusters
thwarters1542843thwarters
tickers133617723t_ickers
tidiers8389773t_idiers
tiers55526523t_i__ers
tigers75616513t_i_gers
tilers63523503t_i_lers
tillers73418743t_illers
tilter63417693t_ilter_
timbers113111853t_imbers
timers84420993t_i_mers
tinders84219173t_inders
tinkers113517143t_inkers
tinners73717313t_inners
tinter63923643t_inter_
tippers113414353t_ippers
tipster9299053tipster_
titer55430613t_i_ter_
titfers10318933t_itfers
tithers104216733t_ithers
titres64718933t_i_tres
titter63421163t_itter_
toaster74414463toaster_
toilers74116263toi_lers
tooters73818773t_ooters
tossers74713503t_ossers
toters65026363t__oters
totters74618733t_otters
touters74018353t_outers
trashers113013643trashers
treaters83615843treaters
trickers143812813trickers
tricksters16264763tricksters
triers64321523tri__ers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tri_mers
trimesters1245413trimesters
trimeters1139203trimeters
trimmers12288913trimmers
trippers123210163trippers
triste63818643triste__
tristeza1742933tristeza
tristezas1842743tristezas
triter65120593tri_ter_
trotters83310243trotters
trussers8348273trussers
trustees8339323trustees
truster73114313truster_
trustors8268913trustors
tryster10369513tryster_
trystes10419993tryste_s
tufters10298353t_ufters
tuskers113710043t_uskers
tussers74313563t_ussers
twangers12226063twangers
tweeners11306243tweeners
tweeter10288533tweeter_
tweezers20254383tweezers
twiddlers14313693twiddlers
twier84713293twi__er_
twigless1293663twigless
twiner94012593twi_ner_
twines94717273twi_ne_s
twinges11409453twinge_s
twinier1037313twinier_
twinjets1842413twinjets
twinklers1633063twinklers
twinsets1133663twinsets
twirler10285203twirler_
twist86820983twist___
twistiest1235433twistiest
twisting12427813twisting
twistings13264353twistings
twisty12426863twist__y
twitchers17134533twitchers
twits86015793twi_t__s
twitted11326633twitte_d
twittered1333813twittered
twitterer1243303twitterer
twitterers1342673twitterers
twofers1364053tw_ofers
twyers12497413tw__yers
ulsters72711983_ulsters
uniters73814173uni_ters
visiters1137413_visiters
wafters134112813_wafters
waister103812383waister_
waiters104218623_waiters
wanters104420093_wanters
washers134517523_washers
waster95228943_waster_
wastery134610993_wastery
wastes96224883_waste_s
waters95030633_w_aters
websters1335803websters
welters103516063_welters
wester94222893_wester_
western102911093_western
westerns11328963_westerns
wetters103817753_wetters
whiskers18306773whiskers
whispers16266993whispers
whistlers1595163whistlers
whitters14359403whitters
wickers164114703_wickers
widders123512273_widders
wieners103212483_wieners
wilders113513503_wilders
willers103517913_willers
wincers123415363_wincers
winders113721263_winders
wingers113921483_wingers
winkers143517113_winkers
winners104316913_winners
winter94222803_winter_
wintery13399753_wintery
wipers115416083_wi_pers
wirers94617893_wi_rers
wiser85522803_wis_er_
wises85633193_wis_e_s
wisher123617063_wisher_
wishes124920953_wishe_s
wisses94619603_wisse_s
wisted104120273_wiste_d
wisteria1147743_wisteria
wisterias1248093_wisterias
wists86728523_wist__s
wites85536963_wi_te_s
withers134417753_withers
wivers125320803_wi_vers
wresters112711733wresters
writers105513493_writers
xysters17307163_xysters
zesters163517293_zesters
zosters163015413_zosters

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.190940478.9
2DLD Change Limit1461624116.76321612.0
3Display Results4114110.1732375.7
 (SQL Overall)1786914117.12625075.9
 
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.